IntermediateKeyboard Shortcuts
Add the dollar signs without typing them
Cycle a reference through its absolute and relative forms while editing.
4 min20 points
Edit the cell you are standing on
The situation
You are checking a colleague's commission sheet and need to look inside a formula without retyping it. Double-clicking works but loses your place, and clicking into the formula bar means leaving the keyboard every time.
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
Type today's date without typing it
Stamp the current date into a cell as a fixed value.
3 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 - IntermediateKeyboard Shortcuts
Select to the bottom of the data
Extend a selection to the last filled row in one press.
4 min20 points