Subset
Search
K

Spreadsheet Shortcuts

Action
Mac
PC
Notes
Examine formula
ENTER or F2
ENTER or F2
This is the key to the left of the 1 key
Escape cell
ESC (or Enter again)
ESC (or Enter again)
Only works when editing individual cell
Delete cells
BACKSPACE
BACKSPACE
Deletes entire range
Move to end of range
CMD + ARROW KEY
CTRL + ARROW KEY
When cursor is on a cell
Select a range
SHIFT + ARROW KEY
SHIFT + ARROW KEY
Drag formula right
(CMD or CTRL) + R
CTRL + R
Drag formula down
(CMD or CTRL) + D
CTRL + D
Access next block
TAB
TAB
Cycles through your blocks
Add Row or Column
(CMD or CTRL) SHIFT +
CTRL SHIFT +
Depends on if you have row or col selected
Delete Row or Column
(CMD or CTRL) SHIFT -
CTRL SHIFT -
Depends on if you have row or col selected
Select Row
SHIFT SPACE
SHIFT SPACE
Select Column
CTRL SPACE
CTRL SPACE