MORE SITES OF US

INDIA AYURVEDIC site related to ayurvedic www.indiaayur.co.cc KEYBOARD SHORTCUTS KEYS site related to more shortcuts keys of keyboards KEYBOARD SHORTCUTS KEYS RACHIT this site is related to world stock market www.rsrocks.co.cc

LIVE COUNTER

Splash Web DirectoryInCrawler Web Directory

Search This Blog

Ads

Shaadi.com

Keyboard shortcuts for Windows

•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)

MS-Excels Keyboard Shortcuts

Action

Menu equivalent
comments

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

Print

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

Print

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