Excel Shortcuts Quick Reference
WORKBOOK
EDITING
CTRL+O Opens a workbook
CTRL+SHIFT+:
Enters the current time
CTRL+N
Create a new workbook
CTRL+;
Enters the current date
CTRL+P Displays the print dialog box CTRL+S
CTRL+C
Copies the selected cells
Save the workbook
CTRL+D
Copies topmost cell of a
CTRL+W Closes the selected workbook
range into the cells below.
CTRL+F2
Displays print view
CTRL+R
Copies leftmost cell of a
F9
Calculates all open workbooks
range into cells to right
SHIFT+F9
Calculates the active worksheet
CTRL+F
Find dialog box
CTRL+F10
CTRL+H+
Maxmize/restore workbook
Replace dialog box
SHIFT+F11
Inserts a new worksheet
CTRL+K
Edit hyperlink
F12
CTRL+T
Displays the Save As dialog box
Create Table dialog box
CTRL+V
Paste CTRL+ALT+V Paste Special Dialog box
FORMATTING
CTRL+X
Cuts the selected cells
CTRL+SHIFT+
Applies general format
CTRL+Z
Undoes last action
CTRL+SHIFT+$
Applies currency format with two decimal places
SHIFT+F2
Adds/edits comment
F4
Generates absolute and
CTRL+SHIFT+%
Applies percentage format with no decimal places.
relative references Spell check
F7
CTRL+SHIFT+# Applies date format CTRL+SHIFT+@
ALT+= ALT+F8
Autosum
Applies time format
Opens Macro Dialog box
CTRL+SHIFT+!
Applies the Number format with two decimal places,
ALT+F11
Opens VB Editor
ALT+D+P Opens pivot table wizard
thousands separator Displays the Format Cells box M
ALT+A+M
Removes duplicates
CTRL+1
ALT+A+E Text to columns Wizard
CONTE
ALT+ENTER
Enters a new line
GENERAL
ALT+D+L Data validation
CTRL+~
Toggles values and formulas
SHIFT+F3
Insert Function dialog box
NAVIGATION
CTRL+F3 ALT+M+V
Name manager box
Evaluate formula box
TAB
Left cell to right cell
CTRL+SHIFT+U
Expand/collapse of the formula bar
SHIFT+TAB Right cell to left cell
CTRL+G or F5
Go To dialog box
CTRL+F1
Displays or hides the Ribbon
CTRL+END Moves to last used cell
CTRL+SHIFT+L Applies/removes filter
CTRL+Home
Moves to the first used cell
ALT+A+Q
Advanced filter
ALT+PAGE Moves one screen to the
DOWN
ATL+T+0
Excel options
right in a worksheet.
CTRL+PAGE Moves to the next sheet in a workbook
DOWN
SELECTION
ALT+PAGE UP Moves one screen to the
CTRL+A
Selects the entire worksheet (Press 3 times)
left in a worksheet
CTRL+PAGE Moves to the previous UP
F8
Toggles extend mode
sheet in a workbook
CTRL+SPACEBAR Selects an entire column
CTRL+Arrow Moves to the edge of the current data region
SHIFT+SPACEBAR
Selects an entire row
