Excel Shortcut Keys
Alt Key Shortcut
ALT + =
AutoSum numbers
ALT + ENTER
Line break in same cell
ALT + F1
Insert Chart
ALT + F2
Save As
ALT + F4
Exit Excel
ALT + F8
Macro Basic Editor
ALT + F11
Visual Basic (VBA) Editor
ALT + DOWN
Open Dropdown / Filter list
ALT + H + O + I
Auto-fit Column Width
ALT + H + O + A
Auto-fit Row Height
ALT + H + M + C
Merge & Center
ALT + H + V + V
Paste Values Only
ALT + H + B + A
Apply All Borders
ALT + A + T
Toggle Data Filters
ALT + A + M
Remove Duplicates
ALT + W + F + F
Freeze / Unfreeze Panes
ALT + PAGE DOWN
Scroll Screen Right
ALT + PAGE UP
Scroll Screen Left
A to Z Ctrl Key Shortcut
CTRL + A
Select all cells
CTRL + B
Bold
CTRL + C
Copy
CTRL + D
Fill down
CTRL + E
Flash Fill
CTRL + F
Find
CTRL + G
Go To dialog
CTRL + H
Find & Replace
CTRL + I
Italics
CTRL + K
Insert Hyperlink
CTRL + L
Create Table
CTRL + N
New Workbook
CTRL + O
Open Workbook
CTRL + P
Print
CTRL + Q
Quick Analysis
CTRL + R
Fill right
CTRL + S
Save Workbook
CTRL + T
Create Table
CTRL + U
Underline
CTRL + V
Paste
CTRL + W
Close Workbook
CTRL + X
Cut
CTRL + Y
Redo
CTRL + Z
Undo
Function Key Shortcut
F1
Help
F2
Edit Cells
F3
Paste Name into formula
F4
Repeat Action / Anchor $
F5
Go To dialog
F6
Switch Panes / Ribbon
F7
Spell Check
F8
Extend Mode
F9
Recalculate workbooks
F10
Activate Menu Bar / Ribbon
F11
Create Chart Sheet
F12
Save As
Ctrl Key Shortcut
CTRL + 0
Hide Columns
CTRL + 1
Format Cells Dialog Box
CTRL + 5
Strikethrough text
CTRL + 8
Toggle Outline Symbols
CTRL + 9
Hide Row
CTRL + ;
Insert Current Date
CTRL + SHIFT + :
Insert Current Time
CTRL + `
Toggle Show Formulas
CTRL + '
Copy formula from above
CTRL + "
Copy value from above
CTRL + +
Insert Row / Column / Cell
CTRL + -
Delete Row / Column / Cell
CTRL + ENTER
Fill selected cell range
CTRL + SPACE
Select entire Column
SHIFT + SPACE
Select entire Row
CTRL + BACKSPACE
Scroll to Active Cell
Shift + Function Shortcut
SHIFT + F1
Context Help / What's This
SHIFT + F2
Insert / Edit Cell Note
SHIFT + F3
Insert Function Dialog
SHIFT + F4
Find Next match
SHIFT + F5
Find Dialog
SHIFT + F6
Previous Pane / Ribbon
SHIFT + F7
Thesaurus Pane
SHIFT + F8
Add to Selection Mode
SHIFT + F9
Recalculate Active Sheet
SHIFT + F10
Display Context Menu
SHIFT + F11
New Worksheet
SHIFT + F12
Save Workbook
Number & Formatting Shortcut
CTRL + SHIFT + ~
General Number Format
CTRL + SHIFT + $
Currency Format ($)
CTRL + SHIFT + %
Percentage Format (%)
CTRL + SHIFT + ^
Scientific Format (Exp)
CTRL + SHIFT + #
Date Format (DD-MMM-YY)
CTRL + SHIFT + @
Time Format (HH:MM AM/PM)
CTRL + SHIFT + !
Number Format (2 decimals)
CTRL + SHIFT + &
Apply Outline Border
CTRL + SHIFT + _
Remove Outline Border
CTRL + SHIFT + 9
Unhide Rows
CTRL + SHIFT + 0
Unhide Columns
Navigation & Selection Shortcut
CTRL + ARROWS
Jump to edge of data
CTRL + SHIFT + ARROWS
Select to edge of data
CTRL + HOME
Move to cell A1
CTRL + END
Move to last used cell
CTRL + SHIFT + HOME
Select to cell A1
CTRL + SHIFT + END
Select to last cell
CTRL + PAGE DOWN
Next Worksheet
CTRL + PAGE UP
Previous Worksheet
SHIFT + ARROWS
Extend selection by 1 cell
TAB / SHIFT + TAB
Move Right / Left
ENTER / SHIFT + ENTER
Move Down / Up
Ctrl + Function Shortcut
CTRL + F1
Show / Hide Ribbon
CTRL + F2
Print Preview
CTRL + F3
Name Manager
CTRL + F4
Close Workbook Window
CTRL + F5
Restore Window Size
CTRL + F6
Next Workbook Window
CTRL + F9
Minimize Window
CTRL + F10
Maximize Window
CTRL + F12
Open File
Formulas & Pivot Shortcut
ALT + M + D
Trace Precedents
ALT + M + P
Trace Dependents
ALT + M + A + A
Remove Tracer Arrows
CTRL + [
Select Direct Precedents
CTRL + ]
Select Direct Dependents
F9 (in formula)
Evaluate Expression
CTRL + SHIFT + U
Expand Formula Bar
ALT + N + V + T
Create Pivot Table
ALT + F5
Refresh Pivot Table
CTRL + ALT + F5
Refresh All Data
ALT + SHIFT + RIGHT
Group Items
ALT + SHIFT + LEFT
Ungroup Items
Was this article helpful?
Comments
0Share your thoughts, questions, or feedback about this guide.