Microsoft Excel keyboard shortcuts

Microsoft Excel keyboard shortcuts

By learning Keyboard Short cuts you can work on any version on ms-office, you can also do work fast without click on menus or tabs, you need not to search for functionality.

మీరు కీబోర్డ్ షార్ట్ కట్ (key board short cuts )కీస్ నేర్చుకోవడం వల్ల మీరు వర్క్ వేగంగా చెయ్య గలరు. కావున మీరు కీబోర్డ్ షార్ట్ కట్ కీస్ నేర్చుకోవడం ఎంతగానో అవసరం. అందుకొరకు మేము మీకోసం .....

General

Description	Shortcut Key
New file	Ctrl + N
Open file	Ctrl + O
Save file	Ctrl + S
Move between open workbooks	Ctrl + F6
Close file	Ctrl + F4
Save as	F12
Display the print menu	Ctrl + P
Select whole spreadsheet	Ctrl + A
Select column	Ctrl + Space
Select row	Shift + Space
Undo last action	Ctrl + Z
Redo last action	Ctrl + Y
Start a formula	Equals Sign (eg. SUM(A1+A2)
Exit Excel 97	Alt + F4

Navigating

Description	Shortcut Key
Move to next cell in row	Tab
Move to previous cell in row	Shift + Tab
Up one screen	Page Up
Down one screen	Page Down
Move to next worksheet	Ctrl + Page Down
Move to previous worksheet	Ctrl + Page Up
Go to first cell in data region	Ctrl + Home
Go to last cell in data region	Ctrl + End

Formatting Text In Worksheet

Description	Shortcut Key
Bold toggle for selection	Ctrl + B
Italic toggle for selection	Ctrl + I
Underline toggle for selection	Ctrl + U
Strikethrough for selection	Ctrl + 5
Change the font	Ctrl + Shift + F
Change the font size	Ctrl + Shift + P
Apply outline borders	Ctrl + Shift + 7
Remove all borders	Ctrl + Shift + Underline
Wrap text in same cell	Alt + Enter

Formatting Cells

Description	Shortcut Key
Format cells	Ctrl + 1
Select font	Ctrl + Shift + F
Select point size	Ctrl + Shift + P
Format as currency	Ctrl + Shift + 4
Format as general (to remove any formatting)	Ctrl + Shift + # (hash sign)
Format as percentage	Ctrl + Shift + 5
Format as number	Ctrl + Shift + 1

Editing/Deleting Text

Description	Shortcut Key
Delete one character to right	Delete
Delete one character to left	Backspace
Edit active cell	F2
Cancel cell entry	Escape Key

Highlighting Cells

Description	Shortcut Key
Select entire worksheet	Ctrl + A
Select entire row	Shift + Spacebar
Select entire column	Ctrl + Spacebar
Manual select	Hold Shift + with Left, Right, Up, Down Arrow Key

Copying and Moving Text

Description	Shortcut Key
Cut	Ctrl + X
Copy	Ctrl + C
Paste	Ctrl + V

Inserting Text Automatically

Description	Shortcut Key
Autosum a range of cells	Alt + Equals Sign
Insert the date	Ctrl + ; (semi-colon)
Insert the time	Ctrl + Shift + ; (semi-colon)
Insert columns/rows	Ctrl + Shift + + (plus sign)
Insert a new worksheet	Shift + F11

Miscellaneous

Description	Shortcut Key
Find text	Ctrl + F
Replace text dialog	Ctrl + H
Create a chart automatically on new sheet	F11
Edit a cell comment	Shift + F2

Main Jaws Keystrokes In Excel

 

Description	Shortcut Key
Say Version of Excel	Ctrl + Shift + V
Move to Next Sheet	Ctrl + Page Down
Move to Prior Sheet	Ctrl + Page Up
Go to a cell command	Ctrl + G
Collapse Selection To Active Cell	Shift + Backspace
Say Active Cell Coordinates	Insert + C
AutoSum	Alt + Equals
Formula Mode	Equals Sign
Insert Date In Current Cell	Ctrl + ; (semicolon)
Insert Time In Current Cell	Ctrl + Shift + ; (semicolon)
Current Column First Cell From Top	Alt + 1
Current Column Second Cell From Top	Alt + 2
Current Column Third Cell From Top	Alt + 3
Current Column Fourth Cell From Top	Alt + 4
Data Region Left	Ctrl + Left Arrow
Data Region Right	Ctrl + Right Arrow
Data Region Down	Ctrl + Down Arrow
Data Region Up	Ctrl + Up Arrow
Select Whole Data Region	Ctrl + Shift + 8
Say Formula	Ctrl + F2
Spell Check	F7
Report Gridline Status	Alt + Shift + g
Read Row Total	Insert + Delete
Read Column Total	Insert + Enter
Say Column Title	Alt + Shift + C
Say Row Title	Alt + Shift + R
Say Visible Range Coordinates	Alt + Shift + V
Cycle Through Controls in Dialog Box	Tab
Tab Backwards	Shift + Tab
List Cells With Comments	Ctrl + Shift + ' (apostrophe)
Row Second Cell From Left	Alt + Ctrl + 2
Row First Cell From Left	Alt + Ctrl + 1
Row Third Cell From Left	Alt + Ctrl + 3
Row Fourth Cell From Left	Alt + Ctrl + 4
Describe Cell Border	Alt + Shift + B
Read Cell Comment	Alt + Shift + ' (apostrophe)
Auto Filter	Ctrl + Shift + A
Read Cell Hyperlink	Alt + Shift + H
Close Office Assistant	Ctrl + Insert + F4
Set Monitor Cell One	Alt + Ctrl + Shift + 1
Set Monitor Cell Two	Alt + Ctrl + Shift + 2
Set Monitor Cell Three	Alt + Ctrl + Shift + 3
Set Monitor Cell Four	Alt + Ctrl + Shift + 4
Set Monitor Cell Five	Alt + Ctrl + Shift + 5
Set Monitor Cell Six	Alt + Ctrl + Shift + 6
Set Monitor Cell Seven	Alt + Ctrl + Shift + 7
Set Monitor Cell Eight	Alt + Ctrl + Shift + 8
Set Monitor Cell Nine	Alt + Ctrl + Shift + 9
Set Monitor Cell 10	Alt + Ctrl + Shift + 0
Read Monitor Cell One	Alt + Shift + 1
Read Monitor Cell Two	Alt + Shift + 2
Read Monitor Cell Three	Alt + Shift + 3
Read Monitor Cell Four	Alt + Shift + 4
Read Monitor Cell Five	Alt + Shift + 5
Read Monitor Cell Six	Alt + Shift + 6
Read Monitor Cell Seven	Alt + Shift + 7
Read Monitor Cell Eight	Alt + Shift + 8
Read Monitor Cell Nine	Alt + Shift + 9
Read Monitor Cell Ten	Alt + Shift + 0
List Visible Cells With Data	Ctrl + Shift + D
Lists Data In Current Column	Ctrl + Shift + C
List Data In Current Row	Ctrl + Shift + R
Select Hyperlink	Ctrl + Shift + H
Move To Worksheet Listbox	Ctrl + Shift + S
Move To Monitor Cell	Ctrl + Shift + M
Select Worksheet Objects	Ctrl + Shift + O
List Cells At Page Breaks	Ctrl + Shift + B
Options Listbox	Insert + V