Editing

Copy	Ctrl + C
Paste	Ctrl + V
Undo	Ctrl + Z
Redo	Ctrl + Y

File

Open	Ctrl + O
New	Ctrl + N
Save	Ctrl + S
Save as	F12
Next workbook	Ctrl + Tab
Close file	Ctrl + F4
Close all files	Alt + F4
Print	Ctrl + P

Formatting

Open format dialog	Ctrl + 1
Bold	Ctrl + B
Italic	Ctrl + I
Underline	Ctrl + U
Number format	Ctrl + Shift + !
Percent format	Ctrl + Shift + %
Date format	Ctrl + Shift + #
Insert / edit comment	Shift + F2
Increase font size	Alt + H + F + G
Decrease font size	Alt + H + F + K
Increase decimal	Alt + H + 0
Decrease decimal	Alt + H + 9
Increase indent	Alt + H + 6
Decrease indent	Alt + H + 5

Paste Special

Paste special formats	Ctrl + Alt + V + T
Paste special values	Ctrl + Alt + V + V
Paste special formulas	Ctrl + Alt + V + F
Paste special comments	Ctrl + Alt + V + C

Borders

Outline border	Ctrl + Shift + &
Remove border	Ctrl + Shift + -
Left border	Alt + H + B + L
Right border	Alt + H + B + R
Top border	Alt + H + B + T
Bottom border	Alt + H + B + O

Navigation

Move across cells	Arrows
Go to end of contiguous range	Ctrl + Arrows
Move one screen up	PgUp
Move one screen down	PgDn
Move one screen left	Alt + PgUp
Move one screen right	Alt + PgDn
Go to cell A1	Ctrl + Home
Go to beginning of row	Home
Go to last cell in worksheet	Ctrl + End
Display Go To box	F5

Data Selection

Select a cell range	Shift + Arrows
Highlight a contiguous range	Ctrl + Shift + Arrows
Extend selection up one screen	Shift + PgUp
Extend selection down one screen	Shift + PgDn
Extend selection down one screen	Alt + Shift + PgUp
Extend selection right one screen	Alt + Shift + PgDn
Select all	Ctrl + A

Data Editing

Fill down from cell above	Ctrl + D
Fill right from cell left	Ctrl + R
Find and replace	Ctrl + F
Show all constants	F5 + Alt + S + O
Highlight cells with comments	F5 + Alt + S + C

Editing Within a Cell

Edit active cell	F2
Use arrows to create a reference	F2
Confirm change and exit cell	Enter
Cancel change and exit cell	Esc
Insert line break within cell	Alt + Enter
Highlight within cell	Shift + Left / Right
Highlight contiguous items	Ctrl + Shift + Left / Right
Jump to beginning of cell	Home
Jump to end of cell	End
Delete character to left	Backspace
Delete character to right	Delete
Accept autocomplete suggestion	Tab
Reference a cell from another sheet	Ctrl + PgUp / PgDn

Auditing Formulas

Inspect cell values	F9
Switch to formula view	Ctrl + ~
Select direct precedents	Ctrl + [
Select direct dependents	Ctrl + ]
Trace immediate precedents	Alt + M + P
Trace immediate dependents	Alt + M + D
Remove tracing arrows	Alt + M + A + A
Go to last cell	F5 + Enter

Utilities

Recalculate all sheets	F9
Options dialog	Alt + T + O
Access data validation	Alt + A + V + V
Get inside drop-down list	Alt + Up / Down
Insert data table	Alt + A + W + T
Sort a data range	Alt + A + S + S
Autofilter selection	Alt + A + T
Insert a pivot table	Alt + N + V
Insert a chart	Alt + N + R
Record a macro	Alt + L + R
Name a cell	Ctrl + F3
Zoom	Alt + W + Q

Navigating Across Sheets

Jump to next sheet	Ctrl + PgDn
Jump to previous sheet	Ctrl + PgUp
Change sheet name	Alt + H + O + R
Rarrange tab order	Alt + H + O + M
Freeze pane	Alt + W + F + F
Split screen	Alt + W + S
Toggle ribbon bar	F6

Rows and Columns

Select column	Ctrl + Spacebar
Select row	Shift + Spacebar
Delete row / column	Ctrl + -
Add row / column	Ctrl + Shift + +
Set column width	Alt + H + O + W
Autofit column width	Alt + H + O + I
Fit to specific row height	Alt + H + O + H
Group rows / columns	Alt + Shift + Right
Ungroup rows / columns	Alt + Shift + Left

📹 Resources