IntermediateKeyboard Shortcuts
Select to the bottom of the data
Extend a selection to the last filled row in one press.
4 min20 points
Fill a formula down a column
The situation
You have written a margin formula on the first row of a two-hundred-row order export. Dragging the fill handle that far means scrolling with the mouse held down and overshooting at least once.
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
- IntermediateKeyboard Shortcuts
Select to the bottom of the data
Extend a selection to the last filled row in one press.
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 - BeginnerKeyboard Shortcuts
Type today's date without typing it
Stamp the current date into a cell as a fixed value.
3 min10 points