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
|