| File & Edit |
|---|
| New spreadsheet | ⌘N |
| Open | ⌘O |
| Save | ⌘S |
| Print | ⌘P |
| Undo | ⌘Z |
| Redo | ⌘Y |
| Cut | ⌘X |
| Copy | ⌘C |
| Paste | ⌘V |
| Paste special | ⌘⇧V |
| After copying cells: paste with Enter | Enter |
| Check spelling in current sheet | F7 |
| Open thesaurus for cell text | ⌘F7 |
| Cells & Formulas |
|---|
| Edit cell | F2 |
| Insert sum | ⌥= |
| Confirm and stay | ⌥Enter |
| Insert current date | ⌘; |
| Insert current time | ⌘⇧; |
| Toggle absolute reference | ⇧F4 |
| Recalculate | F9 |
| Show formulas | ⌘` |
| Focus formula input line | ⇧⌘F2 |
| Delete selected cells | ⌘- |
| Show current cell comment | ⌘F1 |
| Open Define Names dialog | ⌘F3 |
| Open Function Wizard | ⌘F2 |
| Trace dependent cells | ⇧F5 |
| Trace precedent cells | ⇧F9 |
| Insert cells | ⌘++ |
| Toggle value highlighting | ⌘F8 |
| Recalculate all formulas in all sheets | ⇧⌘F9 |
| Update selected chart | ⌘F9 |
| Group selected data range | F12 |
| Ungroup selected data range | ⌘F12 |
| Navigation & Selection |
|---|
| Go to cell A1 | ⌘Home |
| Go to last cell | ⌘End |
| Jump to data edge | ⌘Arrow |
| Select whole column | ⌃Space |
| Select whole row | ⇧Space |
| Select all | ⌘A |
| Next sheet | ⌘PageDown |
| Previous sheet | ⌘PageUp |
| Move to current row start | Home |
| Move to last populated column | End |
| Scroll one screen left | ⌥PageUp |
| Scroll one screen right | ⌥PageDown |
| Focus Name Box from input line | ⇧⌘F5 |
| Extend cell selection to row start | ⇧Home |
| Extend cell selection to last populated column | ⇧End |
| Extend cell selection one screen up | ⇧PageUp |
| Extend cell selection one screen down | ⇧PageDown |
| Extend selection to data block edge | ⇧⌘←(arrowkeys)/⇧⌘→(arrowkeys)/⇧⌘↑(arrowkeys)/⇧⌘↓(arrowkeys) |
| Select current data block with numeric keypad | ⌘*(numerickeypad) |
| Select matrix formula range with numeric keypad | ⌘/(numerickeypad) |
| Selection: move to next cell | Enter |
| Selection: move to previous cell or paste | ⇧Enter |
| Toggle additional cell selection mode | F8 |
| Toggle data source explorer | ⇧⌘F4 |
| Toggle Navigator | F5 |
| Extend sheet selection to previous sheet | ⇧⌘PageUp |
| Extend sheet selection to next sheet | ⇧⌘PageDown |
| Pivot dialog: focus next area or button | Tab |
| Pivot dialog: focus previous area or button | ⇧Tab |
| Pivot dialog: focus item above | ↑ |
| Pivot dialog: focus item below | ↓ |
| Pivot dialog: focus item left | ← |
| Pivot dialog: focus item right | → |
| Pivot dialog: focus first item | Home |
| Pivot dialog: focus last item | End |
| Pivot dialog: move field up | ⌘↑ |
| Pivot dialog: move field down | ⌘↓ |
| Pivot dialog: move field left | ⌘← |
| Pivot dialog: move field right | ⌘→ |
| Pivot dialog: move field first | ⌘Home |
| Pivot dialog: move field last | ⌘End |
| Pivot dialog: remove current field | Backspace |
| Formatting |
|---|
| Bold | ⌘B |
| Italic | ⌘I |
| Underline | ⌘U |
| Format cells | ⌘1 |
| Find & Replace | ⌘⌥F |
| Find | ⌘F |
| Increase current column width | ⌥→ |
| Decrease current column width | ⌥← |
| Optimize column width or row height | ⌥⇧←(arrowkeys)/⌥⇧→(arrowkeys)/⌥⇧↑(arrowkeys)/⌥⇧↓(arrowkeys) |
| Toggle Styles window | ⌘T |
| Apply number format with two decimals | ⇧⌘1 |
| Apply scientific number format | ⇧⌘2 |
| Apply standard date format | ⇧⌘3 |
| Apply standard currency format | ⇧⌘4 |
| Apply percentage format with two decimals | ⇧⌘5 |
| Apply standard number format | ⇧⌘6 |
