IntermediateKeyboard Shortcuts
Select to the bottom of the data
Extend a selection to the last filled row in one press.
4 min20 points
Add the dollar signs without typing them
The situation
Your lookup range needs locking before you fill it down, and typing four dollar signs into the middle of a formula by hand is fiddly enough that most people skip it — which is exactly how the range ends up sliding.
On a Mac, Cmd counts as Ctrl. Tab still moves focus, so you can always leave this field.
Who this is for
Recommended next
Related exercises
- AdvancedLookup & Reference
Lock ranges so a lookup survives fill-down
Use absolute references so a lookup does not break when copied down a column.
XLOOKUP
12 min40 points - AdvancedData Analysis
Fill a two-way summary with SUMIFS
Write one formula that stays correct filled both across and down a grid.
SUMIFS
14 min40 points - BeginnerKeyboard Shortcuts
Edit the cell you are standing on
Open a cell for editing without reaching for the mouse or the formula bar.
2 min10 points