| • | CTRL+C (Copy) |
| • | CTRL+X (Cut) |
| • | CTRL+V (Paste) |
| • | CTRL+Z (Undo) |
| • | DELETE (Delete) |
| • | SHIFT+DELETE (Delete the selected item permanently without placing the item in the Recycle Bin) |
| • | CTRL while dragging an item (Copy the selected item) |
| • | CTRL+SHIFT while dragging an item (Create a shortcut to the selected item) |
| • | F2 key (Rename the selected item) |
| • | CTRL+RIGHT ARROW (Move the insertion point to the beginning of the next word) |
| • | CTRL+LEFT ARROW (Move the insertion point to the beginning of the previous word) |
| • | CTRL+DOWN ARROW (Move the insertion point to the beginning of the next paragraph) |
| • | CTRL+UP ARROW (Move the insertion point to the beginning of the previous paragraph) |
| • | CTRL+SHIFT with any of the arrow keys (Highlight a block of text) |
| • | SHIFT with any of the arrow keys (Select more than one item in a window or on the desktop, or select text in a document) |
| • | CTRL+A (Select all) |
| • | F3 key (Search for a file or a folder) |
| • | ALT+ENTER (View the properties for the selected item) |
| • | ALT+F4 (Close the active item, or quit the active program) |
| • | ALT+ENTER (Display the properties of the selected object) |
| • | ALT+SPACEBAR (Open the shortcut menu for the active window) |
| • | CTRL+F4 (Close the active document in programs that enable you to have multiple documents open simultaneously) |
| • | ALT+TAB (Switch between the open items) |
| • | ALT+ESC (Cycle through items in the order that they had been opened) |
| • | F6 key (Cycle through the screen elements in a window or on the desktop) |
| • | F4 key (Display the Address bar list in My Computer or Windows Explorer) |
| • | SHIFT+F10 (Display the shortcut menu for the selected item) |
| • | ALT+SPACEBAR (Display the System menu for the active window) |
| • | CTRL+ESC (Display the Start menu) |
| • | ALT+Underlined letter in a menu name (Display the corresponding menu) |
| • | Underlined letter in a command name on an open menu (Perform the corresponding command) |
| • | F10 key (Activate the menu bar in the active program) |
| • | RIGHT ARROW (Open the next menu to the right, or open a submenu) |
| • | LEFT ARROW (Open the next menu to the left, or close a submenu) |
| • | F5 key (Update the active window) |
| • | BACKSPACE (View the folder one level up in My Computer or Windows Explorer) |
| • | ESC (Cancel the current task) |
| • | SHIFT when you insert a CD-ROM into the CD-ROM drive (Prevent the CD-ROM from automatically playing) |
| • | CTRL+SHIFT+ESC (Open Task Manager) |
MORE SITES OF US
Search This Blog
Ads
Shaadi.com
Keyboard shortcuts for Windows
MS-Excels Keyboard Shortcuts
Action | Menu equivalent | Version | |
| Ctrl+A | Select All | None | All |
| Ctrl+B | Bold | Format, Cells, Font, Font Style, Bold | All |
| Ctrl+C | Copy | Edit, Copy | All |
| Ctrl+D | Fill Down | Edit, Fill, Down | All |
| Ctrl+F | Find | Edit, Find | All |
| Ctrl+G | Goto | Edit, Goto | All |
| Ctrl+H | Replace | Edit, Replace | All |
| Ctrl+I | Italic | Format, Cells, Font, Font Style, Italic | All |
| Ctrl+K | Insert Hyperlink | Insert, Hyperlink | Excel 97/2000 |
| Ctrl+N | New Workbook | File, New | All |
| Ctrl+O | Open | File, Open | All |
| Ctrl+P | | File, Print | All |
| Ctrl+R | Fill Right | Edit, Fill Right | All |
| Ctrl+S | Save | File, Save | All |
| Ctrl+U | Underline | Format, Cells, Font, Underline, Single | All |
| Ctrl+V | Paste | Edit, Paste | All |
| Ctrl W | Close | File, Close | Excel 97/2000 |
| Ctrl+X | Cut | Edit, Cut | All |
| Ctrl+Y | Repeat | Edit, Repeat | All |
| Ctrl+Z | Undo | Edit, Undo | All |
| F1 | Help | Help, Contents and Index | All |
| F2 | Edit | None | All |
| F3 | Paste Name | Insert, Name, Paste | All |
| F4 | Repeat last action | Edit, Repeat. Works while not in Edit mode. | All |
| F4 | While typing a formula, switch between absolute/relative refs | None | All |
| F5 | Goto | Edit, Goto | All |
| F6 | Next Pane | None | All |
| F7 | Spell check | Tools, Spelling | All |
| F8 | Extend mode | None | All |
| F9 | Recalculate all workbooks | Tools, Options, Calculation, Calc,Now | All |
| F10 | Activate Menubar | N/A | All |
| F11 | New Chart | Insert, Chart | All |
| F12 | Save As | File, Save As | All |
| Ctrl+: | Insert Current Time | None | All |
| Ctrl+; | Insert Current Date | None | All |
| Ctrl+" | Copy Value from Cell Above | Edit, Paste Special, Value | All |
| Ctrl+' | Copy Fromula from Cell Above | Edit, Copy | All |
| Shift | Hold down shift for additional functions in Excel's menu | none | Excel 97/2000 |
| Shift+F1 | What's This? | Help, What's This? | All |
| Shift+F2 | Edit cell comment | Insert, Edit Comments | All |
| Shift+F3 | Paste function into formula | Insert, Function | All |
| Shift+F4 | Find Next | Edit, Find, Find Next | All |
| Shift+F5 | Find | Edit, Find, Find Next | All |
| Shift+F6 | Previous Pane | None | All |
| Shift+F8 | Add to selection | None | All |
| Shift+F9 | Calculate active worksheet | Calc Sheet | All |
| Shift+F10 | Display shortcut menu | None | All |
| Shift+F11 | New worksheet | Insert, Worksheet | All |
| Shift+F12 | Save | File, Save | All |
| Ctrl+F3 | Define name | Insert, Names, Define | All |
| Ctrl+F4 | Close | File, Close | All |
| Ctrl+F5 | XL, Restore window size | Restore | All |
| Ctrl+F6 | Next workbook window | Window, ... | All |
| Shift+Ctrl+F6 | Previous workbook window | Window, ... | All |
| Ctrl+F7 | Move window | XL, Move | All |
| Ctrl+F8 | Resize window | XL, Size | All |
| Ctrl+F9 | Minimize workbook | XL, Minimize | All |
| Ctrl+F10 | Maximize or restore window | XL, Maximize | All |
| Ctrl+F11 | Inset 4.0 Macro sheet | None in Excel 97. In versions prior to 97 - Insert, Macro, 4.0 Macro | All |
| Ctrl+F12 | File Open | File, Open | All |
| Alt+F1 | Insert Chart | Insert, Chart... | All |
| Alt+F2 | Save As | File, Save As | All |
| Alt+F4 | Exit | File, Exit | All |
| Alt+F8 | Macro dialog box | Tools, Macro, Macros in Excel 97 Tools,Macros - in earlier versions | Excel 97/2000 |
| Alt+F11 | Visual Basic Editor | Tools, Macro, Visual Basic Editor | Excel 97/2000 |
| Ctrl+Shift+F3 | Create name by using names of row and column labels | Insert, Name, Create | All |
| Ctrl+Shift+F6 | Previous Window | Window, ... | All |
| Ctrl+Shift+F12 | | File, Print | All |
| Alt+Shift+F1 | New worksheet | Insert, Worksheet | All |
| Alt+Shift+F2 | Save | File, Save | All |
| Alt+= | AutoSum | No direct equivalent | All |
| Ctrl+` | Toggle Value/Formula display | Tools, Options, View, Formulas | All |
| Ctrl+Shift+A | Insert argument names into formula | No direct equivalent | All |
| Alt+Down arrow | Display AutoComplete list | None | Excel 95 |
| Alt+' | Format Style dialog box | Format, Style | All |
| Ctrl+Shift+~ | General format | Format, Cells, Number, Category, General | All |
| Ctrl+Shift+! | Comma format | Format, Cells, Number, Category, Number | All |
| Ctrl+Shift+@ | Time format | Format, Cells, Number, Category, Time | All |
| Ctrl+Shift+# | Date format | Format, Cells, Number, Category, Date | All |
| Ctrl+Shift+$ | Currency format | Format, Cells, Number, Category, Currency | All |
| Ctrl+Shift+% | Percent format | Format, Cells, Number, Category, Percentage | All |
| Ctrl+Shift+^ | Exponential format | Format, Cells, Number, Category, | All |
| Ctrl+Shift+& | Place outline border around selected cells | Format, Cells, Border | All |
| Ctrl+Shift+_ | Remove outline border | Format, Cells, Border | All |
| Ctrl+Shift+* | Select current region | Edit, Goto, Special, Current Region | All |
| Ctrl++ | Insert | Insert, (Rows, Columns, or Cells) Depends on selection | All |
| Ctrl+- | Delete | Delete, (Rows, Columns, or Cells) Depends on selection | All |
| Ctrl+1 | Format cells dialog box | Format, Cells | All |
| Ctrl+2 | Bold | Format, Cells, Font, Font Style, Bold | All |
| Ctrl+3 | Italic | Format, Cells, Font, Font Style, Italic | All |
| Ctrl+4 | Underline | Format, Cells, Font, Font Style, Underline | All |
| Ctrl+5 | Strikethrough | Format, Cells, Font, Effects, Strikethrough | All |
| Ctrl+6 | Show/Hide objects | Tools, Options, View, Objects, Show All/Hide | All |
| Ctrl+7 | Show/Hide Standard toolbar | View, Toolbars, Stardard | All |
| Ctrl+8 | Toggle Outline symbols | None | All |
| Ctrl+9 | Hide rows | Format, Row, Hide | All |
| Ctrl+0 | Hide columns | Format, Column, Hide | All |
| Ctrl+Shift+( | Unhide rows | Format, Row, Unhide | All |
| Ctrl+Shift+) | Unhide columns | Format, Column, Unhide | All |
| Alt or F10 | Activate the menu | None | All |
| Ctrl+Tab | In toolbar: next toolbar | None | Excel 97/2000 |
| Shift+Ctrl+Tab | In toolbar: previous toolbar | None | Excel 97/2000 |
| Ctrl+Tab | In a workbook: activate next workbook | None |
Microsoft Natural Keyboard Shortcuts
- Windows Logo (Display or hide the Start menu)
- Windows Logo+BREAK (Display the System Properties dialog box)
- Windows Logo+D (Display the desktop)
- Windows Logo+M (Minimize all of the windows)
- Windows Logo+SHIFT+M (Restore the minimized windows)
- Windows Logo+E (Open My Computer)
- Windows Logo+F (Search for a file or a folder)
- CTRL+Windows Logo+F (Search for computers)
- Windows Logo+F1 (Display Windows Help)
- Windows Logo+ L (Lock the keyboard)
- Windows Logo+R (Open the Run dialog box)
- Windows Logo+U (Open Utility Manager)
Shortcut keys in Tally
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