Jump to: General, Navigation and Selection Shortcuts, Field Selection Shortcuts
Ctrl+A | Select all data |
A | Use Rectangular Selection tool |
Ctrl+B | Smaller cell size |
Ctrl+Shift+B | Bigger cell size |
Ctrl+C | Copy selected data |
Alt+Shift+C | Place selected field on Columns shelf |
Ctrl+D | Connect to data source |
D | Use Lasso Selection Tool |
Ctrl+E | Describe sheet |
Ctrl+F | Makes the find command in the Data pane active |
Alt+Shift+F | Place selected field on Filters shelf |
Ctrl+H | Switch in and out of Presentation Mode |
Alt+Shift+I | Place selected field on Size |
Ctrl+L | Flip orientation of column labels at bottom of view |
Alt+Shift+L | Place selected field on Detail |
Ctrl+M | New worksheet |
Ctrl+N | New workbook |
Ctrl+O | Open file |
Alt+Shift+O | Place selected field on Color |
Ctrl+P | |
Alt+Shift+P | Place selected field on Pages shelf |
Alt+Shift+R | Place selected field on Rows shelf |
Ctrl+S | Save file |
S | Use Radial Selection Tool |
Alt+Shift+S | Place selected field on Shape |
Alt+Shift+T | Place selected field on Text/Label |
Ctrl+V | Paste clipboard |
Ctrl+W | Swap rows and columns |
Ctrl+X | Cut text selection (e.g., in captions, titles, formulas, etc.) |
Alt+Shift+X | Place selected field on Rows shelf |
Ctrl+Y | Redo |
Alt+Shift+Y | Place selected field on Columns shelf |
Ctrl+Z | Undo |
Alt+Shift+Backspace | Clear the current worksheet |
Ctrl+Arrow Left | Make rows narrower |
Ctrl+Arrow Right | Make rows wider |
Ctrl+Arrow Down | Make columns shorter |
Ctrl+Arrow Up | Make columns taller |
Ctrl+1 | Show Me! |
Enter | Add the selected field to the sheet. Only works with a single field |
F1 | Opens the Help |
Ctrl+F4 | Deletes the selected sheet (on a dashboard) |
Alt+F4 | Closes the current workbook |
F4 | Starts and stops forward playback on the pages shelf |
Shift+F4 | Starts and stops backward playback on the pages shelf |
F5 | Refreshes the data source |
Ctrl+, | Skip backward one page |
Ctrl+F6 | Cycle forward through open worksheets |
Ctrl+Shift+F6 | Cycle backward through open worksheets |
F9 | Run update |
F10 | Toggles Automatic Updates on and off |
F12 | Reverts workbook to last saved state |
Esc | Clears the selection (Desktop and Reader only) |
Click | Selects the mark |
Drag | Selects a group of marks |
Ctrl+Click | Adds individual marks to the selection |
Ctrl+Drag | Adds a group of marks to the selection |
Shift+Drag | Pans around the view |
Ctrl+Shift+Click | Zooms in to a point in the view (requires zoom mode if not map) |
Ctrl+Shift+Alt+Click | Zooms out from a point on a map (requires zoom mode if not map) |
Shift+Double-click | Zooms out |
Ctrl+Shift+Drag | Zooms in to an area in the view (requires zoom mode if not map) |
Scroll | Zooms in and out on a map |
Right-click+Drag to shelf | Opens the Drop Field menu |
Ctrl+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