Scrolling through 10,000 rows is where most time goes. These jump straight to the edge of your data.
Windows
Mac
What it does
Ctrl+↓
⌘+↓
Jump to the last filled cell in the column
Ctrl+Home
Fn+Ctrl+←
Go to A1
Ctrl+End
Fn+Ctrl+→
Go to the last used cell
Ctrl+PgDn
Fn+Ctrl+↓
Next worksheet
Ctrl+G
Ctrl+G
Go to a specific cell or name
Select ranges instantly
Windows
Mac
What it does
Ctrl+Shift+↓
⌘+Shift+↓
Select to the end of the data
Ctrl+A
⌘+A
Select the current region (press twice for the sheet)
Shift+Space
Shift+Space
Select the whole row
Ctrl+Space
Ctrl+Space
Select the whole column
Edit and fill without dragging
Select the formula cell plus the empty cells below, then press Ctrl+D. It fills down without the fill handle, which is useful when the column has gaps.
Fill down with Ctrl+D
C2fx=B2*1.2
A
B
C
1
Product
Price
With tax
2
Laptop
100
120
3
Phone
250
300
4
Tablet
80
96
5
Mouse
40
48
C3:C5 were filled from C2 in one keystroke.
Windows
Mac
What it does
F2
Ctrl+U
Edit the active cell
F4
⌘+T
Toggle $ absolute references while editing
Ctrl+D
⌘+D
Fill down
Ctrl+;
Ctrl+;
Insert today’s date
Alt+Enter
Option+Enter
New line inside a cell
Ctrl+E
⌘+E
Flash Fill
Format and finish
Windows
Mac
What it does
Ctrl+1
⌘+1
Open Format Cells
Ctrl+T
Ctrl+T
Turn the range into a Table
Ctrl+Shift+L
⌘+Shift+F
Toggle filters
Try it in a live spreadsheet
Practise these formulas in interactive lessons with instant grading.