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
× Get In Touch With Us!