Excel Shortcut Keys

Basic Excel Shortcuts

Shortcut	Description
Ctrl + N	New workbook
Ctrl + O	Open workbook
Ctrl + S	Save workbook
Ctrl + P	Print
Ctrl + Z	Undo
Ctrl + Y	Redo
Ctrl + C	Copy
Ctrl + X	Cut
Ctrl + V	Paste

Data and Formula Shortcuts

Shortcut	Description
Alt + =	AutoSum (Σ)
Ctrl + (grave accent)	Show/hide formulas
F2	Edit active cell
Ctrl + Shift + $	Apply currency format
Ctrl + Shift + %	Apply percentage format
Ctrl + Shift + #	Apply date format
Ctrl + Enter	Enter same data in selected cells

Navigation and Selection

Shortcut	Description
Ctrl + Arrow Keys	Move to edge of data region
Shift + Arrow Keys	Extend selection by one cell
Ctrl + Shift + Arrow	Select data range
Ctrl + Space	Select entire column
Shift + Space	Select entire row
Ctrl + A	Select entire worksheet

Worksheet and Cell Formatting

Shortcut	Description
Ctrl + 1	Format cells dialog
Ctrl + B	Bold
Ctrl + I	Italic
Ctrl + U	Underline
Alt + H + O + I	Auto-fit column width

Worksheet & Workbook Navigation

Shortcut	Description
Ctrl + Page Up/Page Down	Switch between sheets
Ctrl + Tab	Switch between open workbooks
Ctrl + F	Find
Ctrl + H	Replace