Show Menu
Cheatography
  1. Home >
  2. Software >

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
           
 

Metadata

  • Languages:
  • Published: 14th January, 2015
  • Last Updated: 10th May, 2016
  • Rated: 4 stars based on 4 ratings

Favourited By

SwankyB jacquelinelondre dugfreez Andrey99 Animelover789 young.dev2016 Danitza3 MoakDesigns jusbeinac vinceswann route666

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
          Documents professionnels Cheat Sheet
            Excel Tricks Infographic by STL Training