Show Menu
Cheatography

Excel 2013 Keyboard Shortcuts Keyboard Shortcuts by

CTRL combination shortcut keys, function keys, and some other common shortcut keys for Microsoft Excel 2013

CTRL Combin­ation Shortcut Keys

Ctrl+PgDn
Go to next worksheet tab
Ctrl+PgUp
Go to previous worksheet tab
Ctrl+S­hif­t+&
Add outline border
Ctrl+S­hif­t+&
Add outline border
Ctrl+S­hift_
Removes outline border
Ctrl+S­hift+~
Apply general number format
Ctrl+S­hift+$
Apply currency format
Ctrl+S­hift+%
Apply percentage format
Ctrl+S­hift+%
Apply percentage format
Ctrl+S­hift+^
Apply scientific number format
Ctrl+S­hift+#
Apply date format
Ctrl+S­hift+@
Apply time format
Ctrl+S­hift+!
Apply number format
Ctrl+S­hift+*
Select block of neighb­oring cells
Ctrl+S­hift+:
Enter current time
Ctrl+S­hif­t+"
Copy value of above cell
Ctrl+S­hif­t+Plus (+)
Insert
Ctrl+Minus (-)
Delete
Ctrl+;
Enter current date
Ctrl+`
Alternate between displaying cell values and formulas
Ctrl+'
Copy formula of above cell
Ctrl+1
Format cells
Ctrl+2
Bold
Ctrl+3
Italic
Ctrl+4
Underline
Ctrl+5
Strike­through
Ctrl+6
Hide/Show object
Ctrl+8
Hide/Show outline symbols
Ctrl+9
Hide selected rows
Ctrl+0
Hide selected columns
Ctrl+A
Select entire worksheet
Ctrl+B
Bold
Ctrl+C
Copy
Ctrl+D
Fill down
Ctrl+E
Flash fill
Ctrl+F
Find
Ctrl+G
Display Go To dialog box
Ctrl+H
Find and Replace
Ctrl+I
Italicize
Ctrl+K
Hyperlink
Ctrl+L
Create table
Ctrl+N
Create new workbook
Ctrl+O
Display Open dialog box
Ctrl+P
Print
Ctrl+Q
Quick Analysis
Ctrl+R
Fill right
Ctrl+S
Save
Ctrl+T
Create table
Ctrl+U
Underline
Ctrl+V
Paste
Ctrl+W
Close workbook
Ctrl+X
Cut
Ctrl+Y
Redo
Ctrl+Z
Undo
 

Function Keys

F1
Help
F2
Edit active cell
F3
Paste Name
F4
Redo
F5
Display Go To dialog box
F6
Toggle control
Shift+F6
Toggle Control (reverse)
F7
Spell check
F8
Extend mode
F9
Calculate all worksheets
Shift+F9
Calculate active worksheet
F10
Show/hide key tips
F11
Create Chart sheet
F12
Save As
Ctrl+F1
Show/Hide Ribbon
Alt+F1
Create embedded chart
Alt+Sh­ift+F1
Insert worksheet
Shift+F2
Add/Edit comment
Ctrl+F2
Print Preview
Shift+F3
Insert function
Ctrl+F4
Close workbook
Alt+F4
Close Excel
Ctrl+F6
Switch workbook
Ctrl+F7
Move window
Ctrl+F8
Resize window
Alt+F8
Display Macro dialog box
Ctrl+F9
Minimize window
Shift+F10
Display shortcut menu
Ctrl+F10
Maximi­ze/­Restore window
Shift+F11
Insert worksheet
Alt+F11
Open VBA Editor

Other Common Shortcut Keys

Alt
Show/Hide key tips
Arrow Keys
Move between cells
Ctrl+Arrow Key
Move to edge of current data region
Shift+­Arrow Key
Extend selection
Esc
Cancel entry
Tab
Move to cell to the right
Shift+Tab
Move to cell to the left
           
 

Comments

good

Amazing! Thank you! I'll print it and stack it into my office wall!

Add a Comment

Your Comment

Please enter your name.

    Please enter your email address

      Please enter your Comment.

          Related Cheat Sheets

          VBA for Excel Cheat Sheet
            Excel Tricks Infographic by STL Training