Jump to: General, Navigation and Selection Shortcuts, Field Selection Shortcuts
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) |
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 |
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 |
Advertising for Consideration:
Ads for Consideration:
Please kindly review and accept Terms of Use and Cookie & Policy Policy