| 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 |
