HomeFinancial ReportingRatio AnalysisAccountingCompliancesUtilitiesArticles
.
.
Events Calendar
Tally and Excle Short cuts
 
EXCEL SHORTCUTS TALLY SHORTCUTS OTHER TALLY SHORTCUTS
EXCEL SHORTCUTS
SR NO. FUNCTION SHORTCUT KEYS MENU EQUIVALENT COMMENTS
1 Select All Ctrl+A None
2 Bold Ctrl+B Format,Cells,Font style,Bold
3 Copy Ctrl+C Edit,Copy
4 Fill Down Ctrl+D Edit,Fill,Down
5 Find Ctrl+F Edit,Find
6 Go To Ctrl+G Edit,Go to
7 Replace Ctrl+H Edit,Replace
8 Italic Ctrl+I Format,Cells,Font style,Italic
9 Hyperlink Ctrl+K Insert Hyperlink
10 Create List Ctrl+L None
11 New Workbook Ctrl+N File,New
12 Open Ctrl+O File,Open
13 Print Ctrl+P File,Print
14 Fill Right Ctrl+R Edit,Fill Right
15 Save Ctrl+S File,Save
16 Underline Ctrl+U Format,Cells,Font
style,Underline,Single
17 Paste Ctrl+V Edit,Paste
18 Close File Ctrl+W File,Close
19 Cut Ctrl+X File,Cut
20 redo Ctrl+Y  
21 Undo Ctrl+Z Edit,Undo
22 Help F1 Help,Contents & Index
23 Edit F2 None
24 Paste Name
Convert Relative reference
into Absolute Ref or
F3 Insert,Name,Paste
25 vise e versa F4 $
26 Repeat F4 Edit,Repeat
27 Go To F5 Edit,Go to
28 Spell Check F7 Tools, Spelling
29 Extend Mode F8 shift
30 Activate Menubar F10 N/A
31 New Chart F11 Insert Chart
32 Save As F12 File,Save As
33 Numerical Form Ctrl+Shift+1 Format,Cells,Number
34 Time Format Ctrl+Shift+2 Format,Cells,Date
35 Date Format Ctrl+Shift+3 Format,Cells,Time
36 Currency Format Ctrl+Shift+4 Format,Cells,Currency
37 Percent Format Ctrl+Shift+5 Format,Cells,Number,
Category,Percentage
38 Exponential Format Ctrl+Shift+6 Format,Cells,Number,Category
39 Place outline Borderaround
selected cells
Ctrl+Shift+7 Format,Cells,Border
40 Select current area Ctrl+Shift+8 Edit,Goto,Special,Current Area
41 Unhide Rows Ctrl+Shift+9 Format,Row,Unhide
42 Unhide Coulmns Ctrl+Shift+0 Format,Columns,Unhide
43 Format cells dialogue box Ctrl+1 Format, Cells
44 Bold Ctrl+2 Format,Cells,Font style,Bold
45 Italic Ctrl+3 Format,Cells,Font style,Italic
46 Underline Ctrl+4 Format,Cells,Font style,
Underline,Single
47 Strikethrough Ctrl+5 Formats,Cells,Font,
Effects,Strikethrough
48 Show/Hide Objects Ctrl+6 Tools,Options,View,Objects,
Show All/Hide
49 Show/Hide Standard Toolbar Ctrl+7 View,Toolbar,Standard
50 Toogle OutlineSymbols Ctrl+8 None
51 Hide Rows Ctrl+9 Format,Row,Hide
52 Hide Coulmns Ctrl+0 Format,Columns,Hide
53 Insert Current Date Ctrl+; None
54 Insert Ctrl++ Insert, (Rows,columns,
or cells) Depends on selection
55 Delete Ctrl+- Delete, (Rows,columns,
or cells) Depends on selection
56 Font drop down List Shift+Ctrl+F Format, Cells,Font
57 Point Size Drop down list Shift+Ctrl+P Format, Cells,Font
58 Insert Current Time Ctrl+Shift+: None
59 Remove outline border Ctrl+Shift+_ Format,Cells,Border
60 Activate Menubar Alt None
61 In Toolbar:Previous Toolbar Shift+Ctrl+Tab None
62 In a workbook:Activate
next workbook
Ctrl+Tab None
63 In a workbook:Activate
Previous workbook
Shift+Ctrl+Tab None
64 Next Tool/Cell Tab None
65 Previous Tool Shift+Tab None
66 Start a new line in the same cell Alt+Enter None
67 Fill the selected cell range
with current entry
Ctrl+Enter None
68 Select Column Ctrl+Space None
69 Select Row Shift+Space None
70 Sum of Alt+= Formula
71 Print Ctrl+Shift+F12 File,Print
72 Display Auto complete Sheet Alt+Down Arrow None
73 Comma Format Ctrl+Space None
74 Save Alt+Shift+F2 File,Save
75 Restore window size Ctrl+F5 Restore
76 Maximize window size Ctrl+F10 Maximize
77 Minimize window size Ctrl+F9 Minimize
78 Open Ctrl+F12 File,Open
79 Close/Exit Alt+F4 File,Close
80 Insert Sheet Alt+Shift+F1 Insert, Worksheet
81 Save As Alt+F2 File,Save As
82 Define Name Ctrl+F3 Insert,Name,Define
83 Find Next Shift+F5 Edit,Find
84 New Workbook Shift+F11 File,New
85 Cut Ctrl+X Edit,Cut
86 Top Module Ctrl+Home None
87 End of Module Ctrl+End None
88 Show Formula in entire Work sheet Ctrl+~ None
     
Tally Shortcuts
FUNCTION KEYS
Saving of Voucher Ctrl +A
Creation of Account  in Data Entry Mode Alt+C when the Curser is on Account  Name Field
Calculating the figure and directly put in
Data entry
Alt+C, with this you need not use the Short cut Ctrl+N
Alteration of Account Master in Data
entry mode
Ctrl+Enter when the Curser is on Account Name Field
Viewing the Trial Balance, Group Summery
with Op Balance and Transactions
Alt+”F12”+y+y +Ctrl+A
Transferring the Tally Reports in MS-Excel • With tally 7.2, Click Print, Click Export,
  Set Path C:\-Give Name of the file with extension “.xls”
• Select Format ASCHII delimited
• Select various options and export the file
• Open MS-Excel, Open the exported File, Set Columns   with Mouse
Comparing two accounts ` Display First Account
Click Add Col from the Right Menu
Add New Account of same company or other company You can compare the transactions of two or more accounts by this method.
Change in the Format of Balance sheet Display Balance sheet
Click on Configure button or press “f12”
Select the new display format of Balance Sheet
Change in the format of  Profit and
Loss Account
Display Profit And Loss Account
Click on Configure button or press “f12”
Select the new display format of Balance Sheet
Keeping Voucher in abeyance Pass the voucher as Optional Voucher,  in this mode, the voucher can be seen but posting is not made,  Short cut Key Toggle Alt+L for  creating Optional entry and again Alt+L for regularizing the entry.
See the name of the Data entry Operator Press “D”,”D”, “F12”, select :”Show Entered By/ Altered By” from the Dialogue Box
This feature is available only if Tally Vault is activated.
Department wise financial Results From Main Menu, Select “D”, :”S”,”C”,”O” and then select the cost center of your choice.  You can View the Financial Results from the Screen,
This feature is available only when you create Cost Centers for the internal departments.  This feature is useful to Multi Location Shops, Multi activity Hospitals, Schools Etc.
Insert  Voucher from  Display Alt+I
   
Function Keys
Function Windows Availability
To select the Accounts Button F1 At the Accounting Voucher
creation and alteration screen
To select the Inventory Button F1 (ALT+F1) At the Inventory/Payroll Voucher
creation and alteration screen
To select Payroll Vouchers to alter F1 (CTRL + F1) At the Accounting/Inventory
voucher creation or alteration screen.
To select company inventory features F2 At the F11: Features screen
To select Company Statutory &
Taxation features
F3 Features screen (F11)
To select the Contra voucher F4 At Accounting / InventoryVoucher
creation and alteration screen
To select the Payment voucher F5 At Accounting / Inventory Voucher
creation and alteration screen
To select the Receipt voucher F6 At Accounting / Inventory Voucher
creation and alteration screen
To select the Journal voucher F7 At Accounting / Inventory Voucher
creation and alteration screen
To select the Sales voucher F8 At Accounting / Inventory Voucher
creation and alteration screen
To select the Credit Note voucher F8 (CTRL+F8) At Accounting / Inventory Voucher
creation and alteration screen
     
To select the Debit Note voucher F9 (CTRL+F9) At Accounting / Inventory Voucher
creation and alteration screen
To select the Reversing Journal voucher F10 At Accounting / Inventory Voucher
creation and alteration screen
To select the Memorandum voucher F10 (Ctrl + F10) At Accounting / Inventory / Payroll
Voucher creation and
alteration screen
To select the Functions and Features screen F11 At almost all screens in TALLY
To select the Configure screen F12 At almost all screens in TALLY
     
Special Keys
Function Windows Availability
To Duplicate a voucher ALT + 2 At List of Vouchers – creates a voucher similar to the one
where you positioned the
cursor and used this
key combination
To Add a voucher





To Alter the column in columnar report
ALT + A At List of Vouchers – adds a
voucher after the one where you
positioned the cursor and
used this key combination.

Alters the column in all the
reports which can be viewed
in columnar format
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)





To access Auto Value Calculator in the amount field during voucher entry
ALT + C

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.

At all voucher entry screens in
the Amount field

To delete a voucher

To delete a master

To delete a column in any columnar report
(if it has not been already assigned a different
function, as explained above)
ALT + D At Voucher and Master (Single) alteration screens. Masters can be deleted subject to conditions, as explained in the manual.

All the reports screen which can be viewed in columnar format
To export the report in ASCII, Excel,
HTML OR XML format
ALT + E At all reports screens in TALLY
To insert a voucher




To toggle between Item and
Accounting invoice
ALT + I At List of Vouchers – inserts a voucher before the one where you positioned the cursor and used this key combination.

At creation of sales and purchase invoice
To select the Language Configuration ALT + L At almost all screens in TALLY.
To select the Keyboard Configuration ALT + K At almost all screens in TALLY.
To upload the report at your website ALT + O At all reports screens in TALLY
To select language for Tally Interface ALT + L At almost all screens of TALLY
To Email the report ALT + M At all reports screens in TALLY
To view the report in automatic columns ALT + N At all the reports where columns
can be added
To print the report ALT + P At all reports screens in TALLY
To remove a line in a report ALT + R At all reports screens in TALLY
To bring back a line you removed using
ALT + R
ALT + S At all reports screens in TALLY
To retrieve the last line which is deleted using
Alt + R
ALT + U At all reports screens in Tally
From Invoice screen to bring Stock Journal
screen
ALT+ V At Invoice screen - Quantity Field
- Press Alt + V to select the Stock
Journal.
To view the Tally Web browser. ALT + W At all reports screens in TALLY
To cancel a voucher in Day Book/List
of Vouchers
ALT + X At all voucher screens in TALLY
To Register Tally ALT + R At almost all screens in TALLY.
To accept a form – wherever you use this key
combination, that screen or report gets
accepted as it is.
CTRL + A At almost all screens in TALLY,
except where a specific detail has
to be given before accepting.
To select the Budget CTRL + B At Groups/Ledgers/Cost Centers/
Budgets/Scenarios/Voucher Types/
Currencies (Accounts Info)
creation and alteration screen
To check the Company Statutory details CTRL + ALT + B At all the menu screens
To select the Cost Centre





To select the Cost Category
CTRL + C At Groups/Ledgers/Cost Centers/ 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
To select the Currencies CTRL+ E At Groups/Ledgers/Cost Centers/
Budgets/Scenarios/Voucher Types/
Currencies (Accounts Info)
creation and alteration screen
To select the Group CTRL + G At Groups/Ledgers/Cost Centers/
Budgets/Scenarios/Voucher Types/
Currencies (Accounts Info)
creation and alteration screen
To select the Stock Items CTRL + I At Stock Group/ Stock Categories/
Stock Items/ Reorder Levels/
Godowns/ Voucher Types /
Units of Measure ( Inventory Info)
creation/alteration screen
To import statutory masters Ctrl + Alt + I At all menu screens
To select the Ledger





To mark a Voucher as Optional
CTRL + L At Groups/Ledgers/Cost Centers/ Budgets/Scenarios/Voucher Types/ Currencies (Accounts Info) creation and alteration screen

At the creation and alteration of Vouchers
To select the Godowns CTRL + O At Stock Group/ Stock Categories/
Stock Items/ Reorder Levels/
Godowns/ Voucher Types / Units
of Measure ( Inventory Info) creation/alteration screen
To abandon a form – wherever you use this
key combination, it quits that screen without
making any changes to it.
CTRL + Q At almost all screens in TALLY.
To repeat narration in the same voucher type CTRL + R At creation/alteration of voucher
screen
Rewrite data for a Company CTRL + Alt + R From Gateway of Tally screen
Allows you to alter Stock Item master CTRL + S At Stock Voucher Report and
Godown Voucher Report
To select the Units CTRL + U At Stock Groups/ Stock
Categories/ Stock Items/ Reorder
Levels/ Godowns/ Voucher Types /
Units of Measure ( Inventory Info)
creation/alteration screen
To select the Voucher Types




To toggle between Invoice and Voucher
CTRL + V At Groups/Ledgers/Cost Centers/ Budgets/Scenarios/Voucher Types/ Currencies (Accounts Info) creation and alteration screen

At creation of Sales/Purchase Voucher screen
     
Special Key Combinations
To close a company
To view detailed report
To explode a line into its details
To select Inventory vouchers to alter
ALT + F1 At all menu screens
At almost all report screens At almost all screens in TALLY
At the Inventory/ Payroll voucher creation or alteration screen.
To change the period ALT + F2 At almost all screens in TALLY
To select the company info menu
To create/alter/shut a Company
ALT + F3 At Gateway of Tally screen
To select the Purchase Order Voucher Type ALT + F4 At Accounting / Inventory Voucher
creation and alteration screens
To select the Sales Order Voucher Type


To view monthly and quarterly report
ALT + F5

At Accounting / Inventory Voucher
creation and alteration screens

At almost all report screens in TALLY

To select the Rejection Out Voucher Type

To change the Sales Order Voucher Type
ALT + F6 At Accounting / Inventory Voucher
creation and alteration screens
To select the Stock Journal Voucher Type


To accept all the Audit lists
ALT + F7 At Accounting / Inventory Voucher creation and alteration screens

At Tally Audit Listing screen
To select the Delivery Note Voucher Type

To view the Columnar report
ALT + F8 At Accounting / Inventory Voucher
creation and alteration screens

At Ledger Voucher screen
To select the Receipt Note Voucher Type ALT + F9 At Accounting / Inventory Voucher
creation and alteration screens
To select the Physical Stock Voucher Type ALT + F10 At Accounting / Inventory Voucher
creation and alteration screens
To filter the information based on
monetary value
ALT + F12 At almost all report screens
To select payroll vouchers for alteration Ctrl + F1 At the Accounting/Inventory
Voucher creation or alteration
screen
Advanced Configuration CTRL + ALT +
F12
At Gateway of Tally
     
Key Combination used for navigation
Display previous voucher during voucher
entry/alter
PgUp At voucher entry and alteration
screens

Display next voucher during voucher
entry/alter

PgDn At voucher entry and alteration
screens
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.
ENTER 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)
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.
ESC At almost all screens in TALLY.
Collapse next level details SHIFT + ENTER At Voucher Register screen and
Trial Balance report
To explode a line into its details SHIFT + ENTER In almost all Reports:
At a Group/Stock Group/Cost Category/Godown/Stock Category – displays Sub Groups and Ledgers/Stock Items/Cost Centers/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
To alter a master while making an entry or
viewing a report
CTRL + ENTER

At voucher entry and alteration screens

At all reports

     

foter hisaabkitab logo
FacebookTwitterIn
.
Craft logo
               copyrights © 2013- 2014