Excel shortcuts
Shortcut key
Action
Ctrl+A
Select All
Ctrl+B
Bold
Ctrl+C
Copy
Ctrl+D
Fill Down
Ctrl+F
Find
Ctrl+G
Goto
Ctrl+H
Replace
Ctrl+I
Italic
Ctrl+K
Insert Hyperlink
Ctrl+N
New Workbook
Ctrl+O
Open
Ctrl+P
Print
Ctrl+R
Fill Right
Ctrl+S
Save
Ctrl+U
Underline
Ctrl+V
Paste
Ctrl W
Close
Ctrl+X
Cut
Ctrl+Y
Repeat
Ctrl+Z
Undo
F1
Help
F2
Edit
F3
Paste Name
F4
Repeat last action
F4
While typing a formula, switch between absolute/relative
refs
F5
Goto
F6
Next Pane
F7
Spell check
F8
Extend mode
F9
Recalculate all workbooks
F10
Activate Menubar
F11
New Chart
F12
Save As
Ctrl+:
Insert Current Time
Ctrl+;
Insert Current Date
Ctrl+"
Copy Value from Cell Above
Ctrl+
Copy Formula from Cell Above
Shift
Hold down shift for additional functions in Excels menu
Shift+F1
Whats This?
Shift+F2
Edit cell comment
Shift+F3
Paste function into formula
Shift+F4
Find Next
Shift+F5
Find
Shift+F6
Previous Pane
Shift+F8
Add to selection
Shift+F9
Calculate active worksheet
Ctrl+Alt+F9
Calculate all worksheets in all open workbooks, regardless
of whether they have changed since the last calculation.
Ctrl+Alt+Shift+F9
Rechecks dependent formulas and then calculates all cells
in all open workbooks, including cells not marked as
needing to be calculated.
Shift+F10
Display shortcut menu
Shift+F11
New worksheet
Shift+F12
Save
Ctrl+F3
Define name
Ctrl+F4
Close
Ctrl+F5
XL, Restore window size
Ctrl+F6
Next workbook window
Shift+Ctrl+F6
Previous workbook window
Ctrl+F7
Move window
Ctrl+F8
Resize window
Ctrl+F9
Minimize workbook
Ctrl+F10
Maximize or restore window
Ctrl+F11
Inset 4.0 Macro sheet
Ctrl+F12
File Open
Alt+F1
Insert Chart
Alt+F2
Save As
Alt+F4
Exit
Alt+F8
Macro dialog box
Alt+F11
Visual Basic Editor
Ctrl+Shift+F3
Create name by using names of row and column labels
Ctrl+Shift+F6
Previous Window
Ctrl+Shift+F12
Print
Alt+Shift+F1
New worksheet
Alt+Shift+F2
Save
Alt+=
AutoSum
Ctrl+`
Toggle Value/Formula display
Ctrl+Shift+A
Alt+Down arrow
Alt+
Insert argument names into formula
Display AutoComplete list
Format Style dialog box
Ctrl+Shift+~
General format
Ctrl+Shift+!
Comma format
Ctrl+Shift+@
Time format
Ctrl+Shift+#
Date format
Ctrl+Shift+$
Currency format
Ctrl+Shift+%
Percent format
Ctrl+Shift+^
Exponential format
Ctrl+Shift+&
Place outline border around selected cells
Ctrl+Shift+_
Remove outline border
Ctrl+Shift+*
Select the current region around the active cell. In a
PivotTable report, select the entire PivotTable report.
Ctrl++
Insert
Ctrl+-
Delete
Ctrl+1
Format cells dialog box
Ctrl+2
Bold
Ctrl+3
Italic
Ctrl+4
Underline
Ctrl+5
Strikethrough
Ctrl+6
Show/Hide objects
Ctrl+7
Show/Hide Standard toolbar
Ctrl+8
Toggle Outline symbols
Ctrl+9
Hide rows
Ctrl+0
Hide columns
Ctrl+Shift+(
Unhide rows
Ctrl+Shift+)
Unhide columns
Alt or F10
Ctrl+Tab
Shift+Ctrl+Tab
Tab
Shift+Tab
Enter
Activate the menu
In toolbar: next toolbar
In a workbook: activate next workbook
In toolbar: previous toolbar
In a workbook: activate previous workbook
Next tool
Previous tool
Do the command
Alt+Enter
Start a new line in the same cell.
Ctrl+Enter
Fill the selected cell range with the current entry.
Shift+Ctrl+F
Shift+Ctrl+F+F
Shift+Ctrl+P
Font Drop Down List
Font tab of Format Cell Dialog box
Point size Drop Down List
Ctrl+Spacebar
Select the entire column
Shift+Spacebar
Select the entire row
CTRL+/
CTRL+SHIFT+O
CTRL+\
CTRL+SHIFT+|
CTRL+[
Select the array containing the active cell.
Select all cells that contain comments.
In a selected row, select the cells that dont match the
formula or static value in the active cell.
In a selected column, select the cells that dont match the
formula or static value in the active cell.
Select all cells directly referenced by formulas in the
selection.
CTRL+SHIFT+{
Select all cells directly or indirectly referenced by formulas
in the selection.
CTRL+]
Select cells that contain formulas that directly reference the
active cell.
CTRL+SHIFT+}
ALT+;
SHIFT+BACKSPACE
Select cells that contain formulas that directly or indirectly
reference the active cell.
Select the visible cells in the current selection.
With multiple cells selected, select only the active cell.
Selects the entire worksheet.
If the worksheet contains data, CTRL+SHIFT+SPACEBAR
selects the current region. CTRL+SHIFT+SPACEBAR a
CTRL+SHIFT+SPACEBAR second time selects the entire worksheet.
When an object is selected, CTRL+SHIFT+SPACEBAR
selects all objects on a worksheet
Ctrl+Alt+L
Reapply the filter and sort on the current range so that
changes you've made are included
Ctrl+Alt+V
Displays the Paste Special dialog box. Available only after
you have cut or copied an object, text, or cell contents on a
worksheet or in another program.
Shortcut key
Action
Ctrl+A
Select All
Ctrl+B
Bold
Ctrl+C
Copy
Ctrl+D
Fill Down
Ctrl+F
Find
Ctrl+G
Goto
Ctrl+H
Replace
Ctrl+I
Italic
Ctrl+K
Insert Hyperlink
Ctrl+N
New Workbook
Ctrl+O
Open
Ctrl+P
Print
Ctrl+R
Fill Right
Ctrl+S
Save
Ctrl+U
Underline
Ctrl+V
Paste
Ctrl W
Close
Ctrl+X
Cut
Ctrl+Y
Repeat
Ctrl+Z
Undo
F1
Help
F2
Edit
F3
Paste Name
F4
Repeat last action
F4
While typing a formula, switch between absolute/relative
refs
F5
Goto
F6
Next Pane
F7
Spell check
F8
Extend mode
F9
Recalculate all workbooks
F10
Activate Menubar
F11
New Chart
F12
Save As
Ctrl+:
Insert Current Time
Ctrl+;
Insert Current Date
Ctrl+"
Copy Value from Cell Above
Ctrl+'
Copy Formula from Cell Above
Shift
Hold down shift for additional functions in Excel's menu
Shift+F1
What's This?
Shift+F2
Edit cell comment
Shift+F3
Paste function into formula
Shift+F4
Find Next
Shift+F5
Find
Shift+F6
Previous Pane
Shift+F8
Add to selection
Shift+F9
Calculate active worksheet
Ctrl+Alt+F9
Calculate all worksheets in all open workbooks, regardless
of whether they have changed since the last calculation.
Ctrl+Alt+Shift+F9
Rechecks dependent formulas and then calculates all cells
in all open workbooks, including cells not marked as
needing to be calculated.
Shift+F10
Display shortcut menu
Shift+F11
New worksheet
Shift+F12
Save
Ctrl+F3
Define name
Ctrl+F4
Close
Ctrl+F5
XL, Restore window size
Ctrl+F6
Next workbook window
Shift+Ctrl+F6
Previous workbook window
Ctrl+F7
Move window
Ctrl+F8
Resize window
Ctrl+F9
Minimize workbook
Ctrl+F10
Maximize or restore window
Ctrl+F11
Inset 4.0 Macro sheet
Ctrl+F12
File Open
Alt+F1
Insert Chart
Alt+F2
Save As
Alt+F4
Exit
Alt+F8
Macro dialog box
Alt+F11
Visual Basic Editor
Ctrl+Shift+F3
Create name by using names of row and column labels
Ctrl+Shift+F6
Previous Window
Ctrl+Shift+F12
Print
Alt+Shift+F1
New worksheet
Alt+Shift+F2
Save
Alt+=
AutoSum
Ctrl+`
Toggle Value/Formula display
Ctrl+Shift+A
Alt+Down arrow
Alt+'
Insert argument names into formula
Display AutoComplete list
Format Style dialog box
Ctrl+Shift+~
General format
Ctrl+Shift+!
Comma format
Ctrl+Shift+@
Time format
Ctrl+Shift+#
Date format
Ctrl+Shift+$
Currency format
Ctrl+Shift+%
Percent format
Ctrl+Shift+^
Exponential format
Ctrl+Shift+&
Place outline border around selected cells
Ctrl+Shift+_
Remove outline border
Ctrl+Shift+*
Select current region
Ctrl++
Insert
Ctrl+-
Delete
Ctrl+1
Format cells dialog box
Ctrl+2
Bold
Ctrl+3
Italic
Ctrl+4
Underline
Ctrl+5
Strikethrough
Ctrl+6
Show/Hide objects
Ctrl+7
Show/Hide Standard toolbar
Ctrl+8
Toggle Outline symbols
Ctrl+9
Hide rows
Ctrl+0
Hide columns
Ctrl+Shift+(
Unhide rows
Ctrl+Shift+)
Unhide columns
Alt or F10
Activate the menu
Ctrl+Tab
In toolbar: next toolbar
Shift+Ctrl+Tab
Ctrl+Tab
Shift+Ctrl+Tab
Tab
Shift+Tab
Enter
In toolbar: previous toolbar
In a workbook: activate next workbook
In a workbook: activate previous workbook
Next tool
Previous tool
Do the command
Alt+Enter
Start a new line in the same cell.
Ctrl+Enter
Fill the selected cell range with the current entry.
Shift+Ctrl+F
Shift+Ctrl+F+F
Shift+Ctrl+P
Font Drop Down List
Font tab of Format Cell Dialog box
Point size Drop Down List
Shortcuts for the Visual Basic Editor
Shortcut key
Action
F1
Help
F2
View Object Browser
F3
Find Next
F4
Properies Window
F5
Run Sub/Form or Run Macro
F6
Switch Split Windows
F7
View Code Window
F8
Step Into
F9
Toggle Breakpoint
F10
Activate Menu Bar
Shift+F2
View definition
Shift+F3
Find Previous
Shift+F7
View Object
Shift+F8
Step Over
Shift+F9
Quick Watch
Shift+F10
Show Right Click Menu
Ctrl+F2
Focus To Object Box
Ctrl+F4
Close Window
Ctrl+F8
Run To Cursor
Ctrl+F10
Activate Menu Bar
Alt+F4
Close VBE
Alt+F6
Switch Between Last 2 Windows
Alt+F11
Return To Application
Ctrl+Shift+F2
Go to last position
Ctrl+Shift+F8
Step Out
Ctrl+Shift+F9
Clear All Breakpoints
Insert
Toggle Insert Mode
Delete
Delete
Home
Move to beginning of line
End
Page Up
Move to end of line
Page Up
Page Down
Page Down
Left Arrow
Left
Right Arrow
Up Arrow
Right
Up
Down Arrow
Down
Tab
Indent
Enter
New Line
BackSpace
Delete Prev Char
Shift+Insert
Paste
Shift+Home
Select To Start Of Line
Shift+End
Select To End Of Line
Shift+Page Up
Select To Top Of Module
Shift+Page Down
Select To End Of Module
Shift+Left Arrow
Extend Selection Left 1 Char
Shift+Right Arrow
Shift+Up Arrow
Shift+Down Arrow
Shift+Tab
Alt+Spacebar
Alt+Tab
Alt+BackSpace
Extend Selection Right 1 Char
Extend Selection Up
Extend Selection Down
Outdent
System Menu
Cycle Applications
Undo
Ctrl+A
Select All
Ctrl+C
Copy
Ctrl+E
Export Module
Ctrl+F
Find
Ctrl+G
Immediate Window
Ctrl+H
Replace
Ctrl+I
Turn On Quick Info
Ctrl+J
List Properties/Methods
Ctrl+L
Show Call Stack
Ctrl+M
Import File
Ctrl+N
New Line
Ctrl+P
Print
Ctrl+R
Project Explorer
Ctrl+S
Save
Ctrl+T
Show Available Components
Ctrl+V
Paste
Ctrl+X
Cut
Ctrl+Y
Cut Entire Line
Ctrl+Z
Undo
Ctrl+Insert
Copy
Ctrl+Delete
Delete To End Of Word
Ctrl+Home
Top Of Module
Ctrl+End
End Of Module
Ctrl+Page Up
Top Of Current Procedure
Ctrl+Page Down
End Of Current Procedure
Ctrl+Left Arrow
Move one word to left
Ctrl+Right Arrow
Ctrl+Up Arrow
Move one word to right
Previous Procedure
Ctrl+Down Arrow
Next Procedure
Ctrl+Spacebar
Complete Word
Ctrl+Tab
Cycle Windows
Ctrl+BackSpace
Delete To Start Of Word
Ctrl+Shift+I
Parameter Info
Ctrl+Shift+J
List Constants
Menu equivalent comments
version
None
All
Format, Cells, Font, Font Style, Bold
All
Edit, Copy
All
Edit, Fill, Down
All
Edit, Find
All
Edit, Goto
All
Edit, Replace
All
Format, Cells, Font, Font Style, Italic
All
Insert, Hyperlink
Excel 97/2000 +
File, New
All
File, Open
All
File, Print
All
Edit, Fill Right
All
File, Save
All
Format, Cells, Font, Underline, Single
All
Edit, Paste
All
File, Close
Excel 97/2000 +
Edit, Cut
All
Edit, Repeat
All
Edit, Undo
All
Help, Contents and Index
All
None
All
Insert, Name, Paste
All
Edit, Repeat. Works while not in Edit mode.
All
None
All
Edit, Goto
All
None
All
Tools, Spelling
All
None
All
Tools, Options, Calculation, Calc Now
All
N/A
All
Insert, Chart
All
File, Save As
All
None
All
None
All
Edit, Paste Special, Value
All
Edit, Copy
All
none
Excel 97/2000 +
Help, Whats This?
All
Insert, Edit Comments
All
Insert, Function
All
Edit, Find, Find Next
All
Edit, Find, Find Next
All
None
All
None
All
Tools, Options, Calculation, Calc Sheet
All
None
Excel 97/2000 +
None
Excel 97/2000 +
None
All
Insert, Worksheet
All
File, Save
All
Insert, Names, Define
All
File, Close
All
Restore
All
Window, ...
All
Window, ...
All
XL, Move
All
XL, Size
All
XL, Minimize
All
XL, Maximize
None in Excel 97. In versions prior to 97 - Insert, Macro, 4.0
Macro
File, Open
All
Insert, Chart...
All
File, Save As
All
File, Exit
All
Tools, Macro, Macros in Excel 97 Tools,Macros - in earlier
versions
Excel 97/2000 +
Tools, Macro, Visual Basic Editor
Excel 97/2000 +
Insert, Name, Create
All
Window, ...
All
File, Print
All
Insert, Worksheet
All
File, Save
All
No direct equivalent
All
Tools, Options, View, Formulas
All
No direct equivalent
All
None
Excel 95
Format, Style
All
All
All
Format, Cells, Number, Category, General
All
Format, Cells, Number, Category, Number
All
Format, Cells, Number, Category, Time
All
Format, Cells, Number, Category, Date
All
Format, Cells, Number, Category, Currency
All
Format, Cells, Number, Category, Percentage
All
Format, Cells, Number, Category,
All
Format, Cells, Border
All
Format, Cells, Border
All
Edit, Goto, Special, Current Region
All
Insert, (Rows, Columns, or Cells) Depends on selection
All
Delete, (Rows, Columns, or Cells) Depends on selection
All
Format, Cells
All
Format, Cells, Font, Font Style, Bold
All
Format, Cells, Font, Font Style, Italic
All
Format, Cells, Font, Font Style, Underline
All
Format, Cells, Font, Effects, Strikethrough
All
Tools, Options, View, Objects, Show All/Hide
All
View, Toolbars, Stardard
All
None
All
Format, Row, Hide
All
Format, Column, Hide
All
Format, Row, Unhide
All
Format, Column, Unhide
All
None
All
None
Excel 97/2000 +
None
Excel 97/2000 +
None
Excel 97/2000 +
None
Excel 97/2000 +
None
Excel 97/2000 +
None
Excel 97/2000 +
None
Excel 97/2000 +
Format, Cells, Font
All
Format, Cells, Font
Before 97/2000
Format, Cells, Font
All
None
Excel 97/2000 +
None
Excel 97/2000 +
Data, Reapply
Excel 2007+
Home, Paste, Paste Special...
Excel 2007+
Menu equivalent comments
version
None
All
Format, Cells, Font, Font Style, Bold
All
Edit, Copy
All
Edit, Fill, Down
All
Edit, Find
All
Edit, Goto
All
Edit, Replace
All
Format, Cells, Font, Font Style, Italic
All
Insert, Hyperlink
Excel 97/2000 +
File, New
All
File, Open
All
File, Print
All
Edit, Fill Right
All
File, Save
All
Format, Cells, Font, Underline, Single
All
Edit, Paste
All
File, Close
Excel 97/2000 +
Edit, Cut
All
Edit, Repeat
All
Edit, Undo
All
Help, Contents and Index
All
None
All
Insert, Name, Paste
All
Edit, Repeat. Works while not in Edit mode.
All
None
All
Edit, Goto
All
None
All
Tools, Spelling
All
None
All
Tools, Options, Calculation, Calc Now
All
N/A
All
Insert, Chart
All
File, Save As
All
None
All
None
All
Edit, Paste Special, Value
All
Edit, Copy
All
none
Excel 97/2000 +
Help, What's This?
All
Insert, Edit Comments
All
Insert, Function
All
Edit, Find, Find Next
All
Edit, Find, Find Next
All
None
All
None
All
Tools, Options, Calculation, Calc Sheet
All
None
Excel 97/2000 +
None
Excel 97/2000 +
None
All
Insert, Worksheet
All
File, Save
All
Insert, Names, Define
All
File, Close
All
Restore
All
Window, ...
All
Window, ...
All
XL, Move
All
XL, Size
All
XL, Minimize
All
XL, Maximize
All
None in Excel 97. In versions prior to 97 - Insert, Macro, 4.0
Macro
All
File, Open
All
Insert, Chart...
All
File, Save As
All
File, Exit
All
Tools, Macro, Macros in Excel 97 Tools,Macros - in earlier
versions
Excel 97/2000 +
Tools, Macro, Visual Basic Editor
Excel 97/2000 +
Insert, Name, Create
All
Window, ...
All
File, Print
All
Insert, Worksheet
All
File, Save
All
No direct equivalent
All
Tools, Options, View, Formulas
All
No direct equivalent
All
None
Excel 95
Format, Style
All
Format, Cells, Number, Category, General
All
Format, Cells, Number, Category, Number
All
Format, Cells, Number, Category, Time
All
Format, Cells, Number, Category, Date
All
Format, Cells, Number, Category, Currency
All
Format, Cells, Number, Category, Percentage
All
Format, Cells, Number, Category,
All
Format, Cells, Border
All
Format, Cells, Border
All
Edit, Goto, Special, Current Region
All
Insert, (Rows, Columns, or Cells) Depends on selection
All
Delete, (Rows, Columns, or Cells) Depends on selection
All
Format, Cells
All
Format, Cells, Font, Font Style, Bold
All
Format, Cells, Font, Font Style, Italic
All
Format, Cells, Font, Font Style, Underline
All
Format, Cells, Font, Effects, Strikethrough
All
Tools, Options, View, Objects, Show All/Hide
All
View, Toolbars, Stardard
All
None
All
Format, Row, Hide
All
Format, Column, Hide
All
Format, Row, Unhide
All
Format, Column, Unhide
All
None
All
None
Excel 97/2000 +
None
Excel 97/2000 +
None
Excel 97/2000 +
None
Excel 97/2000 +
None
Excel 97/2000 +
None
Excel 97/2000 +
None
Excel 97/2000 +
None
Excel 97/2000 +
None
Excel 97/2000 +
Format, Cells, Font
All
Format, Cells, Font
Before 97/2000
Format, Cells, Font
All
Menu equivalent comments
Help
View, Object Browser
View, Properties Window
Run, Run Macro
View, Code
Debug, Step Into
Debug, Toggle Breakpoint
View, Definition
View, Object
Debug, Step Over
Debug, Quick Watch
Debug, Run To Cursor
File, Close and Return to Microsoft Excel
View, Last Position
Debug, Step Out
Debug, Clear All Breakpoints
Edit, Clear
Edit, Indent
Edit, Paste
Edit, Outdent
Edit, Select All
Edit, Copy
File, Export File
Edit, Find
View, Immediate Window
Edit, Replace
Edit, Quikc Info
Edit, List Properties/Methods
File, Import File
File, Print
View, Project Explorer
File, Save
Insert, Components...
Edit, Paste
Edit, Cut
Edit, Undo
Edit, Copy
Edit, Complete Word
Edit, Parameter Info
Edit, List Constants
