Shortcut key

Action
Version
Ctrl+A
None
All
Ctrl+B
Format, Cells, Font, Font Style, Bold
All
Ctrl+C
Edit, Copy
All
Ctrl+D
Edit, Fill, Down
All
Ctrl+F
Edit, Find
All
Ctrl+G
Edit, Goto
All
Ctrl+H
Edit, Replace
All
Ctrl+I
Format, Cells, Font, Font Style, Italic
All
Ctrl+K
Insert, Hyperlink
Excel 97/2000
Ctrl+N
File, New
All
Ctrl+O
File, Open
All
Ctrl+P
File, Print
All
Ctrl+R
Edit, Fill Right
All
Ctrl+S
File, Save
All
Ctrl+U
Format, Cells, Font, Underline, Single
All
Ctrl+V
Edit, Paste
All
Ctrl W
File, Close
Excel 97/2000
Ctrl+X
Edit, Cut
All
Ctrl+Y
Edit, Repeat
All
Ctrl+Z
Edit, Undo
All
F1
Help, Contents and Index
All
F2
None
All
F3
Insert, Name, Paste
All
F4
Edit, Repeat. Works while not in Edit mode.
All
F4
None
All
F5
Edit, Goto
All
F6
None
All
F7
Tools, Spelling
All
F8
None
All
F9
Tools, Options, Calculation, Calc,Now
All
F10
N/A
All
F11
Insert, Chart
All
F12
File, Save As
All
Ctrl+:
None
All
Ctrl+;
None
All
Ctrl+"
Edit, Paste Special, Value
All
Ctrl+'
Edit, Copy
All
Shift
none
Excel 97/2000
Shift+F1
Help, What's This?
All
Shift+F2
Insert, Edit Comments
All
Shift+F3
Insert, Function
All
Shift+F4
Edit, Find, Find Next
All
Shift+F5
Edit, Find, Find Next
All
Shift+F6
None
All
Shift+F8
None
All
Shift+F9
Calc Sheet
All
Shift+F10
None
All
Shift+F11
Insert, Worksheet
All
Shift+F12
File, Save
All
Ctrl+F3
Insert, Names, Define
All
Ctrl+F4
File, Close
All
Ctrl+F5
Restore
All
Ctrl+F6
Window, ...
All
Shift+Ctrl+F6
Window, ...
All
Ctrl+F7
XL, Move
All
Ctrl+F8
XL, Size
All
Ctrl+F9
XL, Minimize
All
Ctrl+F10
XL, Maximize
All
Ctrl+F11
None in Excel 97. In versions prior to 97 - Insert, Macro, 4.0 Macro
All
Ctrl+F12
File, Open
All
Alt+F1
Insert, Chart...
All
Alt+F2
File, Save As
All
Alt+F4
File, Exit
All
Alt+F8
Tools, Macro, Macros in Excel 97 Tools,Macros - in earlier versions
Excel 97/2000
Alt+F11
Tools, Macro, Visual Basic Editor
Excel 97/2000
Ctrl+Shift+F3
Insert, Name, Create
All
Ctrl+Shift+F6
Window, ...
All
Ctrl+Shift+F12
File, Print
All
Alt+Shift+F1
Insert, Worksheet
All
Alt+Shift+F2
File, Save
All
Alt+=
No direct equivalent
All
Ctrl+`
Tools, Options, View, Formulas
All
Ctrl+Shift+A
No direct equivalent
All
Alt+Down arrow
None
Excel 95
Alt+'
Format, Style
All
Ctrl+Shift+~
Format, Cells, Number, Category, General
All
Ctrl+Shift+!
Format, Cells, Number, Category, Number
All
Ctrl+Shift+@
Format, Cells, Number, Category, Time
All
Ctrl+Shift+#
Format, Cells, Number, Category, Date
All
Ctrl+Shift+$
Format, Cells, Number, Category, Currency
All
Ctrl+Shift+%
Format, Cells, Number, Category, Percentage
All
Ctrl+Shift+^
Format, Cells, Number, Category,
All
Ctrl+Shift+&
Format, Cells, Border
All
Ctrl+Shift+_
Format, Cells, Border
All
Ctrl+Shift+*
Edit, Goto, Special, Current Region
All
Ctrl++
Insert, (Rows, Columns, or Cells) Depends on selection
All
Ctrl+-
Delete, (Rows, Columns, or Cells) Depends on selection
All
Ctrl+1
Format, Cells
All
Ctrl+2
Format, Cells, Font, Font Style, Bold
All
Ctrl+3
Format, Cells, Font, Font Style, Italic
All
Ctrl+4
Format, Cells, Font, Font Style, Underline
All
Ctrl+5
Format, Cells, Font, Effects, Strikethrough
All
Ctrl+6
Tools, Options, View, Objects, Show All/Hide
All
Ctrl+7
View, Toolbars, Stardard
All
Ctrl+8
None
All
Ctrl+9
Format, Row, Hide
All
Ctrl+0
Format, Column, Hide
All
Ctrl+Shift+(
Format, Row, Unhide
All
Ctrl+Shift+)
Format, Column, Unhide
All