EXCEL SHORTCUTS

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

TALLY SHORTCUT KEYS

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