Click the shortcut category below to view
| Action | Key |
|---|---|
| General | Ctrl Shift 6 |
| Number | Ctrl Shift 1 |
| Percentage | Ctrl Shift 5 |
| Currency | Ctrl Shift 4 |
| Date | Ctrl Shift 3 |
| Scientific | Ctrl Shift 2 |
| Time | hold down Alt and press O U T |
| Action | Key |
|---|---|
| Display or Hide formula in Cell | Ctrl ` |
| Cell Formatting dialog | Ctrl 1 |
| Clear Formatting | Ctrl M |
| Styles and Formatting | F11 |
| Insert Cell dialog | Ctrl + (numeric keypad) |
| Delete Cell dialog | Ctrl - (numeric keypad) |
| Action | Key |
|---|---|
| Select cells with data to top | Ctrl Shift UpArrow |
| Select cells with data to bottom | Ctrl Shift DownArrow |
| Select cells with data to right | Ctrl Shift RightArrow |
| Select cells with data to left | Ctrl Shift LeftArrow |
| Select current cell to the first cell in row | Shift Home |
| Select current cell to the last cell in row | Shift End |
| Selects all cells bounded by empty cells | Ctrl * (numeric keypad) |
| Current selection to one page up | Shift PageUp |
| Current selection to one page down | Shift PageDown |
| Adds previous sheet to sheet selection | Shift Ctrl PageUp |
| Adds next sheet to sheet selection | Shift Ctrl PageDown |
| Toggles additional selection mode | F8 |
| Action | Key |
|---|---|
| Copy | Ctrl C |
| Paste | Ctrl V |
| Paste Special | Ctrl Shift V |
| Find | Ctrl F |
| Find And Replace | Ctrl H |
| Increase column size | Alt RightArrow |
| Decrease column size | Alt LeftArrow |
| Edit Mode | F2 |
| Function Wizard | Ctrl F2 |
| Move cursor to input line | Shift Ctrl F2 |
| Open Define Names Dialog | F3 |
| Shows or Hides Database explorer | F4 |
| Relative Absolute References | Shift F4 |
| Check Spelling | F7 |
| Open Thesaurus | Ctrl F7 |
| Highlight Cells with Values | Ctrl F8 |
| Recalculate changed formulas | F9 |
| Recalculate formuls in all sheets | Ctrl Shift F9 |
| Update Selected Chart | Ctrl F9 |
| Create Document Template | Shift F11 |
| Update Templates | Shift Ctrl F11 |
| Group selected data range | F12 |
| Ungroup selected data range | Shift F12 |