IntermediateKeyboard Shortcuts
Select to the bottom of the data
Extend a selection to the last filled row in one press.
4 min20 points
Paste the numbers, not the formulas
The situation
You are sending a summary to a customer and the cells are full of formulas pointing at sheets they will never receive. Pasted as they are, every figure arrives as a reference error.
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
Fill a formula down a column
Copy the cell above into the cells you have selected, without dragging.
3 min10 points