Short Cut Key of MS Excel

Maneesh Kumar (B.Com M.Com STUDENT CWA IPCC) (507 Points)

19 May 2011

Function

Shortcut Key

Movement within worksheets

Move one cell up, down, left, or right	Arrow Keys
Move one cell to the right	Tab
Move one cell to the left	Shift+Tab
Move to the end of the row	End
Go to last cell in data region	Ctrl+End
Move to the beginning of the row	Home
Move to the beginning of the worksheet	Ctrl+Home
Go to left-most cell in current row	Ctrl+left-arrow
Go to right-most cell in current row	Ctrl+right-arrow
Go to bottom-most cell in current column	Ctrl+down-arrow
Go to top-most cell in current column	Ctrl+up-arrow
Move to next worksheet	Ctrl+Page Down
Move to previous worksheet	Ctrl+Page Up
Move one screen to the right.	Alt+Page Down
Move one screen to the left	Alt+Page Up
Scroll to the active cell when multiple cells are selected	Ctrl+Backspace
Switch sheets	Ctrl+Shift+PageUp/Down

Movement within a selected range

Move from top to bottom within the selected range	Enter
Move from bottom to top within the selected range	Shift+Enter
Move from left to right within the selected range. If cells in a single column are selected, move down.	Tab
Move from right to left within the selected range. If cells in a single column are selected, move up.	Shift+Tab

Entering/editing data

Select the entire worksheet	Ctrl+A
Bold the contents of the selected cell	Ctrl+B
Copy the contents of the selected cell	Ctrl+C
Find words or phrases within the spreadsheet	Ctrl+F
Italicize the contents of the selected cell	Ctrl+I
Print	Ctrl+P
Copy the content of the selected cell right (used in combo with Shift + arrow)	Crtl+R
Save	Ctrl+S
Underline the contents of the selected cell	Ctrl+U
Paste the contents of the selected cell	Ctrl+V
Cut the contents of the selected cell	Ctrl+X
Redo the last action	Ctrl+Y
Undo the last action.	Ctrl+Z
Complete a cell entry and select the cell below	Enter
Complete a cell entry and select the previous cell above	Shift+Enter
Start a new line in the same cell	Alt+Enter
Insert line break in a cell	Ctrl+Enter
Complete a cell entry and select the next cell to the right	Tab
Complete a cell entry and select the previous cell to the left	Shift+Tab
Edit the active cell and position the insertion point at the end of the cell contents	F2
Edit comment	Shift+F2
Cancel cell entry	Esc
Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit cell contents	Backspace
Delete the character to the right of the insertion point, or delete the selection	Delete
Select the entire column	Ctrl+spacebar
Select the entire row	Shift+spacebar
Manual select	Shift+down, up, left, right arrow key
Make a copy of the document	Ctrl+Shift+S
Strikethrough formatting for the contents of the cell	Alt+Shift+5
Apply border outline to selected cells	Alt+Shift+&
Remove border outline from selected cells	Alt+Shift+_
Apply or remove top border from the selected cells	Alt+Shift+T
Apply or remove bottom border from the selected cells	Alt+Shift+B
Apply or remove right border from the selected cells	Alt+Shift+R
Apply or remove left border from the selected cells	Alt+Shift+L

Miscellaneous Shortcuts

Wrap current formula in an ArrayFormula	Ctrl+Shift+Enter
Insert current date into cell	Ctrl+;
Insert current time into cell	Ctrl+:
Open keyboard shortcuts help	Ctrl+/
View all formulas	Ctrl+'

Reply
Follow
Share

Shortcut keys in Tally

The shortcut keys appear in button names in the button bar (right side of the Tally screen). You can either click the button from the button bar or press the relevant function key or character underlined/double-underlined.

The buttons have a function key before the button names ( Eg: F1: Select Cmp) which means you need to press F1 key (Function Key) to select the 'Select Company' screen

The buttons have an underlined character ( Eg: F3:Cmp Info), which means you need to press ALT + F3 to select the 'Company Info' screen.

Some buttons have a double-underlined character (Eg: As Voucher) which means you need to press CTRL + V to select the 'Voucher' in voucher mode.

The shortcut keys available in Tally are listed in the below table:

Function Key Combination

Windows

Functionality

Availability

To select a company

To select the Accounts Button and Inventory buttons

At all masters menu screen

At the Accounting / Inventory Voucher creation and alteration screen

To change the menu period

At almost all screens in TALLY

To select the company

At almost all screens in TALLY

To select the Contra voucher

At Accounting / Inventory Voucher creation and alteration screen

To select the Payment voucher

At Accounting / Inventory Voucher creation and alteration screen

To select the Receipt voucher

At Accounting / Inventory Voucher creation and alteration screen

To select the Journal voucher

At Accounting / Inventory Voucher creation and alteration screen

To select the Sales voucher

At Accounting / Inventory Voucher creation and alteration screen

F8 (CTRL+F8)

To select the Credit Note voucher

At Accounting / Inventory Voucher creation and alteration screen

To select the Purchase voucher

At Accounting / Inventory Voucher creation and alteration screen

F9 (CTRL+F9)

To select the Debit Note voucher

At Accounting / Inventory Voucher creation and alteration screen

F10

To select the Reversing Journal voucher

At Accounting / Inventory Voucher creation and alteration screen

F10

To select the Memorandum voucher

At Accounting / Inventory Voucher creation and alteration screen

F11

To select the Functions and Features screen

At almost all screens in TALLY

F12

To select the Configure screen

At almost all screens in TALLY

Special Key Combination

Windows

Functionality

Availability

ALT + 2

To Duplicate a voucher

At List of Vouchers – creates a voucher similar to the one where you positioned the cursor and used this key combination

ALT + A

To Add a voucher

At List of Vouchers – adds a voucher after the one where you positioned the cursor and used this key combination.

ALT + C

To create a master at a voucher screen (if it has not been already assigned a different function, as in reports like Balance Sheet, where it adds a new column to the report)

At voucher entry and alteration screens, at a field where you have to select a master from a list. If the necessary account has not been created already, use this key combination to create the master without quitting from the voucher screen.

ALT + D

To delete a voucher

To delete a master

(if it has not been already assigned a different function, as explained above)

At Voucher and Master (Single) alteration screens. Masters can be deleted subject to conditions, as explained in the manual.

ALT + E

To export the report in ASCII, SDF, HTML OR XML format

At all reports screens in TALLY

ALT + I

To insert a voucher

At List of Vouchers – inserts a voucher before the one where you positioned the cursor and used this key combination.

ALT + O

To upload the report at your website

At all reports screens in TALLY

ALT + M

To Email the report

At all reports screens in TALLY

ALT + P

To print the report

At all reports screens in TALLY

ALT + R

To remove a line in a report

At all reports screens in TALLY

ALT + S

To bring back a line you removed using ALT + R

At all reports screens in TALLY

ALT+ V

From Invoice screen to bring Stock Journal screen

At Invoice screen à Quantity Field à Press Alt + V to select the Stock Journal.

ALT + W

To view the Tally Web browser.

At all reports screens in TALLY

ALT + X

To cancel a voucher in Day Book/List of Vouchers

At all voucher screens in TALLY

ALT + R

To Register Tally

At Licensing Menu in TALLY

CTRL + A

To accept a form – wherever you use this key combination, that screen or report gets accepted as it is.

At almost all screens in TALLY, except where a specific detail has to be given before accepting.

CTRL + B

To select the Budget

At Groups/Ledgers/Cost Centres/ Budgets/Scenarios/Voucher Types/ Currencies (Accounts Info) creation and alteration screen

CTRL + C

To select the Cost Centre

To select the Cost Category

At Groups/Ledgers/Cost Centres/ Budgets/Scenarios/Voucher Types/ Currencies (Accounts Info) creation and alteration screen

At Stock Groups/ Stock Categories/ Stock Items/ Reorder Levels/ Godowns/ Voucher Types / Units of Measure ( Inventory Info) creation/alteration screen

CTRL+ E

To select the Currencies

At Groups/Ledgers/Cost Centres/ Budgets/Scenarios/Voucher Types/ Currencies (Accounts Info) creation and alteration screen

CTRL + G

To select the Group

At Groups/Ledgers/Cost Centres/ Budgets/Scenarios/Voucher Types/ Currencies (Accounts Info) creation and alteration screen

CTRL + I

To select the Stock Items

At Stock Group/ Stock Categories/ Stock Items/ Reorder Levels/ Godowns/ Voucher Types / Units of Measure ( Inventory Info) creation/alteration screen

CTRL + L

To select the Ledger

At Groups/Ledgers/Cost Centres/ Budgets/Scenarios/Voucher Types/ Currencies (Accounts Info) creation and alteration screen

CTRL + O

To select the Godowns

At Stock Group/ Stock Categories/ Stock Items/ Reorder Levels/ Godowns/ Voucher Types / Units of Measure ( Inventory Info) creation/alteration screen

CTRL + Q

To abandon a form – wherever you use this key combination, it quits that screen without making any changes to it.

At almost all screens in TALLY.

CTRL + Alt + R

Rewrite data for a Company

From Gateway of Tally screen

CTRL + S

Allows you to alter Stock Item master

At Stock Voucher Report and Godown Voucher Report

CTRL + U

To select the Units

At Stock Groups/ Stock Categories/ Stock Items/ Reorder Levels/ Godowns/ Voucher Types / Units of Measure ( Inventory Info) creation/alteration screen

Ctrl + V

To select the Voucher Types

At Groups/Ledgers/Cost Centres/ Budgets/Scenarios/Voucher Types/ Currencies (Accounts Info) creation and alteration screen

Special Function Key Combination

Windows

Functionality

Availability

ALT + F1

To close a company

To view detailed report

To explode a line into its details

At all the menu screen

At almost all report screen

At almost all screens in TALLY

ALT+ F2

To change the system period

At almost all screens in TALLY

ALT + F3

To select the company info menu

To create/alter/shut a Company

At Gateway of Tally screen

ALT + F4

To select the Purchase Order Voucher Type

At Accounting / Inventory Voucher creation and alteration screen

ALT + F5

To select the Sales Order Voucher Type

To view monthly and quarterly report

At Accounting / Inventory Voucher creation and alteration screen

At almost all report screens in TALLY

ALT + F6

To select the Rejection Out Voucher Type

To change the Sales Order Voucher Type

At Accounting / Inventory Voucher creation and alteration screen

ALT + F7

To select the Stock Journal Voucher Type

To accept all the Audit lists

At Accounting / Inventory Voucher creation and alteration screen

At TallyAudit Listing screen

ALT+ F8

To select the Delivery Note Voucher Type

To view the Columnar report

At Accounting / Inventory Voucher creation and alteration screen

At Ledger Voucher screen

ALT + F9

To select the Receipt Note Voucher Type

At Accounting / Inventory Voucher creation and alteration screen

ALT + F10

To select the Physical Stock Voucher Type

At Accounting / Inventory Voucher creation and alteration screen

ALT + F12

To filter the information based on monetary value

At almost all report screens

CTRL + ALT + F12

Advanced Config

At Gateway of Tally

Key Combination used for navigation

Windows

Functionality

Availability

PgUp

Display previous voucher during voucher entry/alter

At voucher entry and alteration screens

PgDn

Display next voucher during voucher entry/alter

At voucher entry and alteration screens

ENTER

To accept anything you type into a field.

To accept a voucher or master

To get a report with further details of an item in a report.

You have to use this key at most areas in TALLY

At the receivables report – press Enter at a pending bill to get transactions relating to this bill (e.g., original sale bill, receipts and payments against this bill, etc)

ESC

To remove what you typed into a field

To come out of a screen

To indicate you do not want to accept a voucher or master.

At almost all screens in TALLY.

SHIFT + ENTER

Collapse next level details

At Voucher Register screen and Trial Balance report

SHIFT + ENTER

To explode a line into its details

In almost all Reports:

At a Group/Stock Group/Cost Category/Godown/Stock Category – displays Sub Groups and Ledgers/Stock Items/Cost Centres/Secondary Godowns/Secondary Stock Categories