The following is a list of keyboard shortcuts for Microsoft Excel. This list is prepared on the basis of the keyboard shortcuts list available in Microsoft Excel Help and also this list is applicable for the U.S. keyboard layout.

 

 

 

 

 

 

 

 

Description

Shortcut Key
General
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 entire worksheet Ctrl + A
Insert a new worksheet Shift + F11
Select column Ctrl + Space
Select row Shift + Space
Undo last action Ctrl + Z
Redo last action Ctrl + Y
Cut Ctrl + X
Copy Ctrl + C
Paste Ctrl + V
Find text Ctrl + F
Replace text dialog Ctrl + H
Edit a cell comment Shift + F2
Delete one character to right Delete
Delete one character to left Backspace
Edit current cell F2
Cancel cell entry Escape Key
Start a formula Equals Sign (e.g. SUM(A1+A2))
Help F1
Go to F5
Exit Excel 97 Alt + F4
Movement
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
Bold Ctrl + B
Italic Ctrl + I
Underline Ctrl + U
Strikethrough 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
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
Highlighting Cells
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
Formulas
Auto sum a range of cells Alt + =
Insert current date Ctrl + ;
Insert current time Ctrl + Shift + ;
Insert columns/rows Ctrl + Shift + +
Miscellaneous
Create a chart automatically on new sheet F11
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 List box 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 List box Insert + V