| General |
WIN |
MAC |
| Select all data |
Ctrl A
|
⌘ A
|
| Use Rectangular Selection tool |
A
|
A
|
| Smaller cell size |
Ctrl B
|
⌘ B
|
| Bigger cell size |
Ctrl Shift B |
⌘ Shift B |
| Copy selected data |
Ctrl C
|
⌘ C
|
| Place selected field on
Columns shelf |
Ctrl Shift C
|
Option Shift C
|
| Connect to data source |
Ctrl D |
⌘ D
|
| Use Lasso Selection Tool |
D
|
D
|
| Describe sheet |
Ctrl E
|
⌘ E
|
| Makes the find command in the
Data pane active |
Ctrl F | ⌘ F
|
| Place selected field on Filters shelf | Alt Shift F |
Option Shift F
|
| Switch in and out of
Presentation Mode |
Ctrl H
|
Option Enter |
| Switch in and out of Presentation Mode |
F7
|
Option Enter
|
| Place selected field on Size |
Alt Shift I
|
Option Shift I |
| Flip orientation of column labels at
bottom of view |
Ctrl L
|
|
| Place selected field on Detail |
Alt Shift L |
Option Shift L |
| New worksheet |
Ctrl N |
⌘ T |
| New workbook |
Ctrl N |
⌘ N |
| Open file |
Ctrl O |
⌘ O |
| Place selected field on Color |
Alt Shift O |
Option Shift O
|
| Print |
Ctrl P |
⌘ P |
| Place selected field on Pages shelf | Alt Shift P |
Option Shift P |
| Place selected field on Rows shelf | Alt Shift R |
Option Shift X |
| Save file |
Ctrl S |
⌘ S |
| Use Radial Selection Tool |
S | S |
| Place selected field on Shape |
Alt Shift S |
Option Shift S |
| Place selected field on Text/Label | Alt Shift T |
Option Shift T |
| Paste clipboard |
Ctrl V |
⌘ V |
| Swap rows and columns |
Ctrl W |
Ctrl ⌘ W |
| Cut text selection (e.g., in captions,
titles, formulas, etc.) |
Ctrl X | ⌘ X |
| Place selected field on Rows shelf | Alt Shift X
|
Option Shift X |
| Redo |
Ctrl Y |
⌘ Shift Z |
| Place selected field on
Columns shelf |
Alt Shift Y |
Option Shift Y |
| Undo |
Ctrl Z |
⌘ Z |
| Clear the current worksheet |
Alt Shift Backspace |
Option Shift del |
| Make rows narrower |
Ctrl ← |
Ctrl ⌘ ← |
| Make rows wider |
Ctrl → |
Ctrl ⌘ → |
| Make columns shorter |
Ctrl ↓ |
Ctrl ⌘ ↓ |
| Make columns taller |
Ctrl ↑ |
Ctrl ⌘ ↑ |
| Show Me! |
Ctrl 1 |
⌘ 1 |
| Add the selected field to the sheet.
Only works with a single field |
Enter | return |
| Opens the Help |
F1 | Ctrl ⌘ ? |
| Closes the current workbook |
Alt F4 |
⌘ W |
| Starts and stops forward playback
on the pages shelf |
F4 | |
| Starts and stops backward playback
on the pages shelf |
Shift F4 |
|
| Refreshes the data source |
F5 | ⌘ R
|
| Skip forward one page |
Ctrl . |
⌘ . |
| Skip backward one page |
Ctrl , |
⌘ , |
| Cycle forward through open
worksheets |
Ctrl Tab | Shift ⌘ } |
| Cycle forward through open
worksheets |
Ctrl F6 | Shift ⌘ } |
| Cycle backward through open
worksheets |
Ctrl Shift Tab |
Shift ⌘ { |
| Cycle backward through open
worksheets |
Ctrl Shift F6 |
Shift ⌘ { |
| Run update |
F9 |
Shift ⌘ O |
| Toggles Automatic
Updates on and off |
F10 | Option ⌘ O |
| Reverts workbook to
last saved state |
F12 | Option ⌘ E
|
| Clears the selection (Desktop and
Reader only) |
Esc | Esc
|
