IntermediateKeyboard Shortcuts
Add the dollar signs without typing them
Cycle a reference through its absolute and relative forms while editing.
4 min20 points
Select to the bottom of the data
The situation
The order export is four thousand rows and you need to select the whole amount column. Scrolling with the mouse takes half a minute and stops in the wrong place; Ctrl+A grabs the headers as well.
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
- BeginnerKeyboard Shortcuts
Fill a formula down a column
Copy the cell above into the cells you have selected, without dragging.
3 min10 points - IntermediateKeyboard Shortcuts
Add the dollar signs without typing them
Cycle a reference through its absolute and relative forms while editing.
4 min20 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