Microsoft Excel Shortcut Keys


Excel

Shortcut Action Menu
Ctrl+A
Ctrl
A
Select AllNone
Ctrl+B
Ctrl
B
BoldFormat Cells Font Font Style Bold
Ctrl+C
Ctrl
C
CopyEdit Copy
Ctrl+D
Ctrl
D
Fill DownEdit Fill Down
Ctrl+F
Ctrl
F
FindEdit Find
Ctrl+G
Ctrl
G
GotoEdit Goto
Ctrl+H
Ctrl
H
ReplaceEdit Replace
Ctrl+I
Ctrl
I
ItalicFormat Cells Font Font Style Italic
Ctrl+K
Ctrl
K
Insert HyperlinkInsert Hyperlink
Ctrl+N
Ctrl
N
New WorkbookFile New
Ctrl+O
Ctrl
O
OpenFile Open
Ctrl+P
Ctrl
P
PrintFile Print
Ctrl+R
Ctrl
R
Fill RightEdit Fill Right
Ctrl+S
Ctrl
S
SaveFile Save
Ctrl+U
Ctrl
U
UnderlineFormat Cells Font Underline Single
Ctrl+V
Ctrl
V
PasteEdit Paste
Ctrl W
Ctrl
W
CloseFile Close
Ctrl+X
Ctrl
X
CutEdit Cut
Ctrl+Y
Ctrl
Y
RepeatEdit Repeat
Ctrl+Z
Ctrl
Z
UndoEdit Undo
F1
F1
HelpHelp Contents and Index
F2
F2
EditNone
F3
F3
Paste NameInsert Name Paste
F4
F4
Repeat last actionEdit Repeat. Works while not in Edit mode.
F4
F4
While typing a formula switch between absolute/relative refsNone
F5
F5
GotoEdit Goto
F6
F6
Next PaneNone
F7
F7
Spell checkTools Spelling
F8
F8
Extend modeNone
F9
F9
Recalculate all workbooksTools Options Calculation Calc,Now
F10
F10
Activate MenubarN/A
F11
F11
New ChartInsert Chart
F12
F12
Save AsFile Save As
Ctrl+:
Ctrl
:
Insert Current TimeNone
Ctrl+;
Ctrl
;
Insert Current DateNone
Ctrl+"
Ctrl
"
Copy Value from Cell AboveEdit Paste Special Value
Ctrl+'
Ctrl
'
Copy Fromula from Cell AboveEdit Copy
Shift
Shift
Hold down shift for additional functions in Excel's menunone
Shift+F1
Shift
F1
What's This?Help What's This?
Shift+F2
Shift
F2
Edit cell commentInsert Edit Comments
Shift+F3
Shift
F3
Paste function into formulaInsert Function
Shift+F4
Shift
F4
Find NextEdit Find Find Next
Shift+F5
Shift
F5
FindEdit Find Find Next
Shift+F6
Shift
F6
Previous PaneNone
Shift+F8
Shift
F8
Add to selectionNone
Shift+F9
Shift
F9
Calculate active worksheetCalc Sheet
Shift+F10
Shift
F10
Display shortcut menuNone
Shift+F11
Shift
F11
New worksheetInsert Worksheet
Shift+F12
Shift
F12
SaveFile Save
Ctrl+F3
Ctrl
F3
Define nameInsert Names Define
Ctrl+F4
Ctrl
F4
CloseFile Close
Ctrl+F5
Ctrl
F5
XL Restore window sizeRestore
Ctrl+F6
Ctrl
F6
Next workbook windowWindow ...
Shift+Ctrl+F6
Shift
Ctrl
F6
Previous workbook windowWindow ...
Ctrl+F7
Ctrl
F7
Move windowXL Move
Ctrl+F8
Ctrl
F8
Resize windowXL Size
Ctrl+F9
Ctrl
F9
Minimize workbookXL Minimize
Ctrl+F10
Ctrl
F10
Maximize or restore windowXL Maximize
Ctrl+F11
Ctrl
F11
Inset 4.0 Macro sheetNone in Excel 97. In versions prior to 97 - Insert Macro 4.0 Macro
Ctrl+F12
Ctrl
F12
File OpenFile Open
Alt+F1
Alt
F1
Insert ChartInsert Chart...
Alt+F2
Alt
F2
Save AsFile Save As
Alt+F4
Alt
F4
ExitFile Exit
Alt+F8
Alt
F8
Macro dialog boxTools Macro Macros in Excel 97 Tools Macros - in earlier versions
Alt+F11
Alt
F11
Visual Basic EditorTools Macro Visual Basic Editor
Ctrl+Shift+F3
Ctrl
Shift
F3
Create name by using names of row and column labelsInsert Name Create
Ctrl+Shift+F6
Ctrl
Shift
F6
Previous WindowWindow ...
Ctrl+Shift+F12
Ctrl
Shift
F12
PrintFile Print
Alt+Shift+F1
Alt
Shift
F1
New worksheetInsert Worksheet
Alt+Shift+F2
Alt
Shift
F2
SaveFile Save
Alt+=
Alt
=
AutoSumNo direct equivalent
Ctrl+`
Ctrl
`
Toggle Value/Formula displayTools Options View Formulas
Ctrl+Shift+A
Ctrl
Shift
A
Insert argument names into formulaNo direct equivalent
Alt+Down arrow
Alt
Display AutoComplete listNone
Alt+'
Alt
'
Format Style dialog boxFormat Style
Ctrl+Shift+~
Ctrl
Shift
~
General formatFormat Cells Number Category General
Ctrl+Shift+!
Ctrl
Shift
!
Comma formatFormat Cells Number Category Number
Ctrl+Shift+@
Ctrl
Shift
@
Time formatFormat Cells Number Category Time
Ctrl+Shift+#
Ctrl
Shift
#
Date formatFormat Cells Number Category Date
Ctrl+Shift+$
Ctrl
Shift
$
Currency formatFormat Cells Number Category Currency
Ctrl+Shift+%
Ctrl
Shift
%
Percent formatFormat Cells Number Category Percentage
Ctrl+Shift+^
Ctrl
Shift
^
Exponential formatFormat Cells Number Category,
Ctrl+Shift+&
Ctrl
Shift
&
Place outline border around selected cellsFormat Cells Border
Ctrl+Shift+_
Ctrl
Shift
_
Remove outline borderFormat Cells Border
Ctrl+Shift+*
Ctrl
Shift
*
Select current regionEdit Goto Special Current Region
Ctrl++
Ctrl
+
InsertInsert (Rows, Columns, or Cells) Depends on selection
Ctrl+-
Ctrl
-
DeleteDelete (Rows, Columns, or Cells) Depends on selection
Ctrl+1
Ctrl
1
Format cells dialog boxFormat Cells
Ctrl+2
Ctrl
2
BoldFormat Cells Font Font Style Bold
Ctrl+3
Ctrl
3
ItalicFormat Cells Font Font Style Italic
Ctrl+4
Ctrl
4
UnderlineFormat Cells Font Font Style Underline
Ctrl+5
Ctrl
5
StrikethroughFormat Cells Font Effects Strikethrough
Ctrl+6
Ctrl
6
Show/Hide objectsTools Options View Objects Show All/Hide
Ctrl+7
Ctrl
7
Show/Hide Standard toolbarView Toolbars Stardard
Ctrl+8
Ctrl
8
Toggle Outline symbolsNone
Ctrl+9
Ctrl
9
Hide rowsFormat Row Hide
Ctrl+0
Ctrl
0
Hide columnsFormat Column Hide
Ctrl+Shift+(
Ctrl
Shift
(
Unhide rowsFormat Row Unhide
Ctrl+Shift+)
Ctrl
Shift
)
Unhide columnsFormat Column Unhide
Alt or F10
Alt
 / 
F10
Activate the menuNone
Ctrl+Tab
Ctrl
Tab
In toolbar: next toolbarNone
Ctrl+Tab
Ctrl
Tab
In a workbook: activate next workbookNone
Shift+Ctrl+Tab
Shift
Ctrl
Tab
In toolbar: previous toolbarNone
Shift+Ctrl+Tab
Shift
Ctrl
Tab
In a workbook: activate previous workbookNone
Tab
Tab
Next toolNone
Shift+Tab
Shift
Tab
Previous toolNone
Enter
Enter
Do the commandNone
Shift+Ctrl+F
Shift
Ctrl
F
Font Drop Down ListFormat Cells Font
Shift+Ctrl+F+F
Shift
Ctrl
F
F
Font tab of Format Cell Dialog boxFormat Cells Font
Shift+Ctrl+P
Shift
Ctrl
P
Point size Drop Down ListFormat Cells Font