EXCEL SHOTCUT KEYS

Miscellaneous
Press To
F4 or Ctrl + Y Repeat last action
Ctrl + F3 Define a name
Shift + F2 Edit /Insert a comment
Ctrl + P Display the Print menu
Shift + F10 Display the shortcut menu
Ctrl + F9 Minimize the active workbook
Ctrl + F10 Maximize or restore the active workbook
Ctrl + A Display the formula palette
(after you type a valid formula name)
Ctrl + Shift + A Insert the argument names and parentheses for a function
(after you type a valid formula name)
Excel Shortcut Key Matrix
Function Key
Only
Shift +
Function Key
Ctrl +
Function Key
Alt +
Function Key
Ctrl + Shift +
Function Key
Alt + Shift +
Function Key
F1 Display
Help
Display
What’s This
Insert
Chart
Insert
Worksheet
F2 Edit
Mode
Insert/Edit
Comment Save As
Save
F3 Paste Name
(in formula)
Paste
Function
Define
Name
Create
Names
F4 Repeat
Last Action
Find
Next
Close
Window Exit Close
Window
Exit
F5 Go To Find Restore
Window
F6 Next Pane
(split window)
Previous Pane
(split window)
Next
Workbook
Previous
Workbook
F7 Spell
Check
Move
Window
F8 Extend
Mode
Add to
Selection
Resize
Window
Macro
(dialog
window)
F9 Calculate
(all sheets)
Calculate
(active sheet)
Minimize
Workbook
F10 Menu Bar
Activate
Display
Shortcut
Menu
Restore
Window
F11 Create
Chart
Insert
Worksheet
Insert
Macro Sheet
Display
VBA Editor
F12 Save As Save Open Print
Note: Shortcuts that appear lighter are less beneficial to most users.
Note: Look up Shortcut in On-Line Help for additional shortcut keys (e.g., Print
Preview shortcuts, Data Form shortcuts, AutoFilter shortcuts, Pivot Table shortcuts,
Outline shortcuts, Toolbar shortcuts, and Dialog Window shortcuts).
Excel
Keyboard Shortcuts
Navigation
Press To Move
Arrow Keys One cell in given direction
Ctrl + Arrow Key To the edge of current data region
Enter / Shift + Enter One cell down / up
Tab / Shift + Tab One cell right / left
Home To the beginning of current row
Ctrl + Home To the beginning of worksheet
Ctrl + End To the end of worksheet
(intersection of last row and column used)
Page Down / Up One screen down / up
Alt + Page Down / Alt + Page Up One screen right / left
Ctrl + Page Down / Page Up To the next / previous sheet
F6 / Shift + F6 To the next / previous pane (in a split worksheet)
Ctrl + F6 / Ctrl + Shift + F6 To the next / previous workbook
Ctrl + Backspace To the active cell (to display the active cell)
Ctrl + . Move clockwise to the corners of the selected range
Ctrl + Alt + Right / Left Arrow Move right / left between nonadjacent selections
Source: Microsoft Excel Help Excel Shortcut Booklet –1/23