TABLE OF CONTENTS This is a list of the keyboard shortcuts I think are most useful for routine modelling. Refer to Excel Help for a full list, using "keyboard shortcut" as the search string, or read the Using Shortcut Keys topic in the Contents of Help.
Press F10 to activate the main menu bar and then Ctrl+Tab to cycle through the toolbars, using the arrow keys to move to the buttons and Enter to select.
| Ctrl+Z | Undo |
| Ctrl+Y | Redo |
| F2 | Edit Cell |
| F4 | Repeat last action |
| Ctrl+R | Fill Right |
| Ctrl+S | Save |
| F12 | Save As |
| Alt+= | Autosum |
| F11 | Create Chart |
| Ctrl+Shift+" | Copy cell above |
| Ctrl+; | Insert date |
| Shift+F10 | Shortcut menu |
| Ctrl+A | Select sheet |
| Shift+Space | Select row |
| Ctrl+Space | Select column |
| Shift+arrow | Select in direction |
| Ctrl+* | Select current region |
| F5 | Go to/Go back |
| Ctrl+PgUp | Next sheet |
| Ctrl+PgDn | Previous sheet |
| Ctrl+Home | Go to A1/top left of sheet |
| Ctrl+End | Go to bottom right of sheet |
| Ctrl+[ | Select precedents |
| Ctrl+] | Select dependents |
| Ctrl+` | View formulas (toggle) |
| Ctrl+Shift+1 | Comma, two decimals |
| Ctrl+Shift+4 | Currency, two decimals |
| Ctrl+Shift+5 | Percentage, no decimals |
| Ctrl+Shift+~ | General number format |
| Ctrl+# | Date format |
| Ctrl+B | Bold |
| Ctrl+I | Italic |
| Alt+Shift+right arrow | Group rows (or columns) |
| Alt+Shift+left arrow | Ungroup rows (or columns) |
| Ctrl+8 (not number keypad) | Display or hide outline symbols |
| Ctrl+9 (not number keypad) | Hide rows |
| Ctrl+Shift+( | Unhide selected rows |
| Ctrl+0 (not number keypad) | Hide columns |
| Ctrl+Shift+) | Unhide columns |
| F3 | Paste names |
| Ctrl+Shift+F3 | Create names |
| Ctrl+F3 | Define... |
