General
| macOS | Action | |
|---|---|---|
| Command+A | Select all data | |
| A | Use Rectangular Selection tool | |
| Command+B | Smaller cell size | |
| Command+Shift+B | Bigger cell size | |
| Command+C | Copy selected data | |
| Option+Shift+C | Place selected field on Columns shelf | |
| Command+D | Connect to data source | |
| D | Use Lasso Selection Tool | |
| Command+E | Describe sheet | |
| Command+F | Makes the find command in the Data pane active | |
| Option+Shift+F | Place selected field on Filters shelf | |
| Ctrl+Command+F | Enter/Exit Full Screen | |
| Option+Enter | Switch in and out of Presentation Mode | |
| Option+Shift+I | Place selected field on Size | |
| Option+Shift+L | Place selected field on Detail | |
| Command+T | New worksheet | |
| Command+N | New workbook | |
| Command+O | Open file | |
| Option+Shift+O | Place selected field on Color | |
| Command+P | ||
| Option+Shift+P | Place selected field on Pages shelf | |
| Option+Shift+R | Place selected field on Rows shelf | |
| Command+S | Save file | |
| S | Use Radial Selection Tool | |
| Option+Shift+S | Place selected field on Shape | |
| Option+Shift+T | Place selected field on Text/Label | |
| Command+V | Paste clipboard | |
| Ctrl+Command+W | Swap rows and columns | |
| Command+X | Cut text selection (e.g., in captions, titles, formulas, etc.) | |
| Option+Shift+X | Place selected field on Rows shelf | |
| Command+Shift+Z | Redo | |
| Option+Shift+Y | Place selected field on Columns shelf | |
| Command+Z | Undo | |
| Option+Shift+Delete | Clear the current worksheet | |
| Ctrl+Command+Arrow Left | Make rows narrower | |
| Ctrl+Command+Arrow Right | Make rows wider | |
| Ctrl+Command+Arrow Down | Make columns shorter | |
| Ctrl+Command+Arrow Up | Make columns taller | |
| Command+1 | Show Me! | |
| Enter | Add the selected field to the sheet. Only works with a single field | |
| Shift+Command+? | Opens the Help | |
| Command+W | Closes the current workbook | |
| Command+R | Refreshes the data source | |
| Command+Period | Skip forward one page | |
| Command+, | Skip backward one page | |
| Shift+Command+Close Brace | Cycle forward through open worksheets | |
| Shift+Command+Open Brace | Cycle backward through open worksheets | |
| Shift+Command+0 | Run update | |
| Option+Command+0 | Toggles Automatic Updates on and off | |
| Option+Command+E | Reverts workbook to last saved state | |
| Esc | Clears the selection (Desktop and Reader only) |
Navigation and Selection Shortcuts
| macOS | Action | |
|---|---|---|
| Click | Selects the mark | |
| Drag | Selects a group of marks | |
| Command+Click | Adds individual marks to the selection | |
| Command+Drag | Adds a group of marks to the selection | |
| Shift+Drag | Pans around the view | |
| Shift+Command+Click | Zooms in to a point in the view (requires zoom mode if not map) | |
| Shift+Option+Command+Click | Zooms out from a point on a map (requires zoom mode if not map) | |
| Shift+Double-click | Zooms out | |
| Shift+Command+Drag | Zooms in to an area in the view (requires zoom mode if not map) | |
| Scroll | Zooms in and out on a map | |
| Command+Hold | Drags a row and scrolls through a long list simultaneously |
Field Selection Shortcuts
| macOS | Action | |
|---|---|---|
| Option+Drag to shelf | Opens the Drop Field menu | |
| Command+Drag | Copies a field in the view to be placed on another shelf or card | |
| Double-click | Adds a field to the view |
