Function | Short cut |
Select All | Ctrl+A |
Bold | Ctrl+B |
Copy | Ctrl+C |
Fill Down | Ctrl+D |
Find | Ctrl+F |
Goto | Ctrl+G |
Replace | Ctrl+H |
Italic | Ctrl+I |
Insert Hyperlink | Ctrl+K |
New Workbook | Ctrl+N |
Open | Ctrl+O |
Ctrl+P | |
Fill Right | Ctrl+R |
Save | Ctrl+S |
Underline | Ctrl+U |
Paste | Ctrl+V |
Close | Ctrl W |
Cut | Ctrl+X |
Repeat | Ctrl+Y |
Undo | Ctrl+Z |
Help | F1 |
Edit | F2 |
Paste Name | F3 |
Repeat last action | F4 |
While typing a formula, switch between absolute/relative refs | F4 |
Goto | F5 |
Next Pane | F6 |
Spell check | F7 |
Extend mode | F8 |
Recalculate all workbooks | F9 |
Activate Menubar | F10 |
New Chart | F11 |
Save As | F12 |
Insert Current Time | Ctrl+: |
Insert Current Date | Ctrl+; |
Copy Value from Cell Above | Ctrl+” |
Copy Formula from Cell Above | Ctrl+’ |
Hold down shift for additional functions in Excel’s menu | Shift |
What’s This? | Shift+F1 |
Edit cell comment | Shift+F2 |
Paste function into formula | Shift+F3 |
Find Next | Shift+F4 |
Find | Shift+F5 |
Previous Pane | Shift+F6 |
Add to selection | Shift+F8 |
Calculate active worksheet | Shift+F9 |
Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation. | Ctrl+Alt+F9 |
Rechecks dependent formulas and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated. | Ctrl+Alt+Shift+F9 |
Display shortcut menu | Shift+F10 |
New worksheet | Shift+F11 |
Save | Shift+F12 |
Define name | Ctrl+F3 |
Close | Ctrl+F4 |
XL, Restore window size | Ctrl+F5 |
Next workbook window | Ctrl+F6 |
Previous workbook window | Shift+Ctrl+F6 |
Move window | Ctrl+F7 |
Resize window | Ctrl+F8 |
Minimize workbook | Ctrl+F9 |
Maximize or restore window | Ctrl+F10 |
Inset 4.0 Macro sheet | Ctrl+F11 |
File Open | Ctrl+F12 |
Insert Chart | Alt+F1 |
Save As | Alt+F2 |
Exit | Alt+F4 |
Macro dialog box | Alt+F8 |
Visual Basic Editor | Alt+F11 |
Create name by using names of row and column labels | Ctrl+Shift+F3 |
Previous Window | Ctrl+Shift+F6 |
Ctrl+Shift+F12 | |
New worksheet | Alt+Shift+F1 |
Save | Alt+Shift+F2 |
AutoSum | Alt+= |
Toggle Value/Formula display | Ctrl+` |
Insert argument names into formula | Ctrl+Shift+A |
Display AutoComplete list | Alt+Down arrow |
Format Style dialog box | Alt+’ |
General format | Ctrl+Shift+~ |
Comma format | Ctrl+Shift+! |
Time format | Ctrl+Shift+@ |
Date format | Ctrl+Shift+# |
Currency format | Ctrl+Shift+$ |
Percent format | Ctrl+Shift+% |
Exponential format | Ctrl+Shift+^ |
Place outline border around selected cells | Ctrl+Shift+& |
Remove outline border | Ctrl+Shift+_ |
Select the current region around the active cell. In a PivotTable report, select the entire PivotTable report. | Ctrl+Shift+* |
Insert | Ctrl++ |
Delete | Ctrl+- |
Format cells dialog box | Ctrl+1 |
Bold | Ctrl+2 |
Italic | Ctrl+3 |
Underline | Ctrl+4 |
Strikethrough | Ctrl+5 |
Show/Hide objects | Ctrl+6 |
Show/Hide Standard toolbar | Ctrl+7 |
Toggle Outline symbols | Ctrl+8 |
Hide rows | Ctrl+9 |
Hide columns | Ctrl+0 |
Unhide rows | Ctrl+Shift+( |
Unhide columns | Ctrl+Shift+) |
Activate the menu | Alt or F10 |
In toolbar: next toolbar | Ctrl+Tab |
In a workbook: activate next workbook | |
In toolbar: previous toolbar | Shift+Ctrl+Tab |
In a workbook: activate previous workbook | |
Next tool | Tab |
Previous tool | Shift+Tab |
Do the command | Enter |
Start a new line in the same cell. | Alt+Enter |
Fill the selected cell range with the current entry. | Ctrl+Enter |
Font Drop Down List | Shift+Ctrl+F |
Font tab of Format Cell Dialog box | Shift+Ctrl+F+F |
Point size Drop Down List | Shift+Ctrl+P |
Select the entire column | Ctrl+Spacebar |
Select the entire row | Shift+Spacebar |
Select the array containing the active cell. | CTRL+/ |
Select all cells that contain comments. | CTRL+SHIFT+O |
In a selected row, select the cells that don’t match the formula or static value in the active cell. | CTRL+\ |
In a selected column, select the cells that don’t match the formula or static value in the active cell. | CTRL+SHIFT+| |
Select all cells directly referenced by formulas in the selection. | CTRL+[ |
Select all cells directly or indirectly referenced by formulas in the selection. | CTRL+SHIFT+{ |
Select cells that contain formulas that directly reference the active cell. | CTRL+] |
Select cells that contain formulas that directly or indirectly reference the active cell. | CTRL+SHIFT+} |
Select the visible cells in the current selection. | ALT+; |
With multiple cells selected, select only the active cell. | SHIFT+BACKSPACE |
Selects the entire worksheet. | CTRL+SHIFT+SPACEBAR |
If the worksheet contains data, CTRL+SHIFT+SPACEBAR selects the current region. CTRL+SHIFT+SPACEBAR a second time selects the entire worksheet. | |
When an object is selected, CTRL+SHIFT+SPACEBAR selects all objects on a worksheet | |
Reapply the filter and sort on the current range so that changes you’ve made are included | Ctrl+Alt+L |
Displays the Paste Special dialog box. Available only after you have cut or copied an object, text, or cell contents on a worksheet or in another program. | Ctrl+Alt+V |
Month: November 2015
TALLY SHORTCUTS | |
Duplicate Voucher | Alt+2 |
Add voucher / To Alter the column in columnar report | Alt+A |
Create a master at a voucher screen (if it has not been already assigned a different function, as in reports like Balance Sheet, wh | Alt+C |
Delete a voucher To delete Accounting or Inventory master which is not used by any voucher or elsewhere in the alteration mode. To | Alt+D |
Export the report in ASCII, HTML OR XML format | Alt+E |
Insert a voucher / To toggle between Item and Accounting invoice | Alt+I |
To view the report in automatic columns (Multiple Columns at all reports, Trial Balance, Cash/bank books, Group Summary & Journal Reg | Alt+N |
Print the report | Alt+P |
Remove a line in a report | Alt+R |
Bring back a line you removed using Alt+R | Alt+S |
Retrieve the last line which is deleted using Alt+R | Alt+U |
To view the Tally Web browser. | Alt+W |
Cancel a voucher in Day Book/List of Vouchers | Alt+X |
Register Tally | Alt+Y |
Accept a form – wherever you use this key combination, that screen or report gets accepted as it is. | Ctrl+A |
Check the Company Statutory details | Ctrl+Alt+B |
Select Group | Ctrl+G |
Import statutory masters | Alt+I |
Abandon a form – wherever you use this key combination, it quits that screen without making any changes to it. | Ctrl+Q |
Rewrite data for a Company | Ctrl+Alt+R |
Help Shortcut | Alt+H |
Maintain Date for Multiple Years by changing period on Gateway of Tally / Change of Period for Setting Period | Alt+F2 |
Switches to Main Area of Tally Screen | Ctrl+M |
Switches to Calculator / ODBC Section of Tally Screen | Ctrl+N |
Recalls the last narration saved for the first ledger in the voucher, irrespective of the voucher type | Alt+R |
Repeat narration in the same voucher type irrespective of Ledger Account | Ctrl+R |
Mark any voucher as Post Dated Voucher | Ctrl+T |
Delete any voucher in Day Book/ Deleting | Alt+D |
To upload the report to the webe | Alt+O |
Email the report | Alt+M |
Close a Company (At All Menu Screens). View detailed Report (Report Screens). Explore a line into its details (At Almost all Screens) | Alt+F1 |
Select the company info menu (At Gateway of Tally Screen). Create/ alter / shut a company (At Gateway of Tally Screen) | Alt+F3 |
View sales and purchase register summary on a quarterly basis | Alt+F5 |
View the filters screen where the range of information can be specified | Alt+F12 |
Zoom | Alt+Z |
Copy the text from Tally (At creation and alternation screens) | Ctrl+Alt+C |
To paste the text from Tally (At creation and alternation screens) | Ctrl+Alt+V |
To view the next level of details and / or condense the next level of details | Shift+Enter |
Change the date | F2 |
Contra Voucher (All voucher creation and alteration screens). View list of Groups (Reports groups summary, group voucher screen, cash/ bank summary) | F4 |
Select Payment Voucher. Switch between Grouped and Ledger-wise Display | F5 |
Select Receipt Voucher | F6 |
Select Journal Voucher | F7 |
Select Sales Voucher | F8 |
Select Purchase Voucher | F9 |
Select Debit Note Voucher | Ctrl+F9 |
Navigate between Accounting Reports | F10 |
Modify Company features specific to current company only | F11 |
Master Configurations, which will affect all companies in same data directory. | F12 |
Mark a voucher as Optional or Regular | Ctrl+L |
Purchase Order Voucher | Alt+F4 |
Sales Order Voucher | Alt+F5 |
Rejection In | Ctrl+F6 |
Stock Journal / Manufacturing Journal | Alt+F7 |
Delivery Note | Alt+F8 |
Receipt Note | Alt+F9 |
Physical Stock | Alt+F10 |
Clear entry | Esc |