Short Cut Key of MS Excel

Excel 3525 views 17 replies

 

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

 

Replies (17)

thank you sir

Supperb Maneesh Kumar,

thank you for sharing

Ronak Darji

very helpful and nice

thanks a lot for sharing the info..

thank you for sharing this awesome work !! 

Gud job done. Keep Sharing.

thanks for sharing..

mr.maneesh kumar

good job..keep it up!

THANK YOU SIR.

thanks buddy .

can u plzz send me short cut keys of TALLY if so plzz share that .

Shortcut keys

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

F1

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

F2

To change the menu period

At almost all screens in TALLY

F3

To select the company

At almost all screens in TALLY

F4

To select the Contra voucher

At Accounting / Inventory Voucher creation and alteration screen

F5

To select the Payment voucher

At Accounting / Inventory Voucher creation and alteration screen

F6

To select the Receipt voucher

At Accounting / Inventory Voucher creation and alteration screen

F7

To select the Journal voucher

At Accounting / Inventory Voucher creation and alteration screen

F8

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

F9

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

At a Voucher – displays its entries and narration

At a Stock Item- displays its godowns and batch details

At Voucher Register screen – displays the next level details

At Trial Balance report - displays the next level details

CTRL + ENTER

To alter a master while making an entry or viewing a report

At voucher entry and alteration screens

At all reports

 

Copyright Tally Solutions Pvt Ltd. 1988-2005. All rights reserved.

Thanks a lot for this ..............

VRY NICE

 


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register