Keyboard Shortcuts
- Matt McManus
- Kelly Nawrocke
Workbook Shortcuts
Command | Keystroke |
|---|---|
Calculate full workbook | Alt + C |
Close workbook | Alt + Q |
Create filter sheet | Alt + F |
Create join sheet | Alt + J |
Create sort sheet | Alt + R |
Create union sheet | Alt + K |
Duplicate sheet | Alt + P |
Exchange data source | Alt + X |
Flip Side | Shift + Alt + F |
Go to line | Alt + E |
Hide/Show column | ALT + H |
Jump to column or sheet | Alt + M |
Link datasource | Alt + D |
Move sheet (up, down, left, right) | ↑, ↓, ←, → |
New workbook | Alt + N |
Open workbook | Alt +O |
Save As | Alt + T |
Save workbook | Alt + S |
Sheet dependency graph | Alt + G |
Submit a formula | ⌘-Enter (mac) and Ctrl-Enter (win) |
Switch among column headers* | Tab |
Switch among columns** | ← and → |
View full results | Alt + A |
Workbook info | Alt + I |
Show partition sunburst | Alt + B |
* For this shortcut to work, you must be in the column header. Example - renaming the column.
** For this to work, you must first click on a column. Then you can switch among the columns in the workbook.