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