Most Used
The essentials — learn these first and save hours every week.
Action
Windows
Mac
Copy
Ctrl + C
⌘ + C
Paste
Ctrl + V
⌘ + V
Cut
Ctrl + X
⌘ + X
Undo
Ctrl + Z
⌘ + Z
Redo
Ctrl + Y
⌘ + Y
Save
Ctrl + S
⌘ + S
Find
Ctrl + F
⌘ + F
Replace
Ctrl + H
⌃ + H
Select all
Ctrl + A
⌘ + A
Open Format Cells
Ctrl + 1
⌘ + 1
Selection
Select rows, columns, and ranges instantly.
Action
Windows
Mac
Select entire row
Shift + Space
Shift + Space
Select entire column
Ctrl + Space
⌃ + Space
Select entire sheet
Ctrl + A
⌘ + A
Extend selection by cell
Shift + Arrow
Shift + Arrow
Extend to edge of data
Ctrl + Shift + Arrow
⌘ + Shift + Arrow
Select current region
Ctrl + Shift + *
⌘ + Shift + *
Editing
Type, edit, and move data without touching the mouse.
Action
Windows
Mac
Edit active cell
F2
⌃ + U
Insert new line in cell
Alt + Enter
⌥ + Enter
Delete cell content
Delete
Delete
Fill down
Ctrl + D
⌘ + D
Fill right
Ctrl + R
⌘ + R
Insert today's date
Ctrl + ;
⌃ + ;
Insert current time
Ctrl + Shift + ;
⌘ + ;
Repeat last action
F4
⌘ + Y
Formatting
Make your data look professional in seconds.
Action
Windows
Mac
Bold
Ctrl + B
⌘ + B
Italic
Ctrl + I
⌘ + I
Underline
Ctrl + U
⌘ + U
Center align
Alt + H, A, C
⌘ + E
Apply percent format
Ctrl + Shift + %
⌃ + Shift + %
Apply currency format
Ctrl + Shift + $
⌃ + Shift + $
Apply date format
Ctrl + Shift + #
⌃ + Shift + #
Open Format Cells
Ctrl + 1
⌘ + 1
Rows, Columns & Cells
Add, remove, hide, and resize in a snap.
Action
Windows
Mac
Insert row/column
Ctrl + Shift + +
⌃ + Shift + +
Delete row/column
Ctrl + -
⌘ + -
Hide row
Ctrl + 9
⌃ + 9
Unhide row
Ctrl + Shift + 9
⌃ + Shift + 9
Hide column
Ctrl + 0
⌃ + 0
Group rows/columns
Shift + Alt + →
⌘ + Shift + K
Ungroup rows/columns
Shift + Alt + ←
⌘ + Shift + J
Formulas & Functions
Write, debug, and copy formulas like a pro.
Action
Windows
Mac
AutoSum
Alt + =
⌘ + Shift + T
Toggle absolute reference
F4
⌘ + T
Show all formulas
Ctrl + `
⌃ + `
Enter formula as array
Ctrl + Shift + Enter
⌃ + Shift + Enter
Insert function
Shift + F3
Fn + Shift + F3
Evaluate selected formula
F9
Fn + F9
Recalculate workbook
F9
Fn + F9
Filtering & Sorting
Slice your data without leaving the keyboard.
Action
Windows
Mac
Turn on AutoFilter
Ctrl + Shift + L
⌘ + Shift + F
Open filter dropdown
Alt + ↓
⌥ + ↓
Open Sort dialog
Alt + A, S, S
—
Clear filter
Alt + A, C
—
Charts & Analysis
From numbers to insights, instantly.
Action
Windows
Mac
Create chart from data
Alt + F1
Fn + ⌥ + F1
Insert chart on new sheet
F11
Fn + F11
Insert PivotTable
Alt + N, V
⌃ + ⌘ + P
Refresh PivotTable
Alt + F5
⌃ + ⌥ + F5
Workbook & Files
Manage workbooks, sheets, and files.
Action
Windows
Mac
New workbook
Ctrl + N
⌘ + N
Open file
Ctrl + O
⌘ + O
Save
Ctrl + S
⌘ + S
Save As
F12
⌘ + Shift + S
Print
Ctrl + P
⌘ + P
Close workbook
Ctrl + W
⌘ + W