Common actions
| Action | Mac | Windows |
|---|---|---|
| Quick command | ⌘ K | ctrl K |
| Copy | ⌘ C | ctrl C |
| Cut | ⌘ X | ctrl X |
| Paste | ⌘ V | ctrl V |
| Redo | ⌘ Y or ⌘ shift z | ctrl Y or ctrl shift z |
| Undo | ⌘ Z | ctrl Z |
Edit cells
| Action | Mac | Windows |
|---|---|---|
| Edit cell | enter or fn F2 | enter or F2 |
| Cancel edit cell | esc | esc |
| Insert line break in cell | ⌘ enter or ctrl enter | ctrl enter |
Format cells
| Action | Mac | Windows |
|---|---|---|
| Bold | ⌘ B | ctrl B |
| Italic | ⌘ I | ctrl I |
| Underline | ⌘ U | ctrl U |
Navigate spreadsheet
| Action | Mac | Windows |
|---|---|---|
| Find in table | ⌘ F | ctrl F |
| Go to the edge of the current data area | ⌘ arrow keys | ctrl arrow keys |
Select and edit rows & columns
| Action | Mac | Windows |
|---|---|---|
| Select row | shift space | shift space |
| Select column | ctrl space | ctrl space |
| Select all | ⌘ A | ctrl A |
| Expand selection | shift arrow keys | shift arrow keys |
| Expand selection to the edge of the current data area | ⌘ shift arrow keys | ctrl shift arrow keys |
| Fill down | ⌘ D | ctrl D |
| Fill right | ⌘ R | ctrl R |
Use formulas
| Action | Mac | Windows |
|---|---|---|
| Toggle between point mode and compose mode | ⌘ E or fn F2 | ctrl E or F2 |
| Toggle absolute and relative references when entering a formula | fn F4 | F4 |