Reference: Worksheets Keyboard Shortcuts
Keyboard shortcuts are intended for use with US English keyboards. Results might vary with different keyboard layouts.
In addition to standard keyboard shortcuts, we provide access to Worksheets functionality using a user interface overlay of action keys typically referred to as KeyTips. You enable KeyTips by pressing the Alt key on Windows or Option on Mac. After you press Alt or Option, small icons depicting keyboard keys are overlaid in the workbook. Press a key to do the displayed action.
Edit
A double asterisk (**) in a cell indicates that the default Mac OS key assignment conflicts with this shortcut. To change your settings, select
Apple > System Preferences > Keyboard > Shortcuts
. Click Mission Control, then clear the shortcut option.Action | Windows | Mac |
|---|---|---|
Cut | Ctrl+X | Command+X |
Copy | Ctrl+C | Command+C |
Copy as External Reference | Ctrl+Alt+R | Command+Option+R |
Copy Workbook ID | Alt+F3 | Option+F3 |
Find | Ctrl+V | Command+F |
Find and Replace | Ctrl+H | Command+Shift+H |
Paste | Ctrl+V | Command+V |
Undo | Ctrl+Z | Command+Z |
Redo | Ctrl+Y | Command+Y |
Insert Row Above | Ctrl+Alt+= | Command+Option+= |
Insert Column Left | Ctrl+Alt+= | Command+Option+= |
Insert New Sheet Right | Shift+F11 or Alt+F2 | Shift+F11** or Option+F2 |
Delete Row | Ctrl+Alt+- | Command+Option+- |
Delete Column | Ctrl+Alt+- | Command+Option+- |
Download as PDF/Print | Ctrl+P | Command+P |
Paste Into Selected Cells | Ctrl+Enter | Command+Enter |
Break Line in Cell | Alt+Enter | Option+Enter |
Submit Unconstrained Array Formula | Ctrl+Alt+Enter or Ctrl+Alt+Shift+Enter | Command+Option+Enter |
Submit Constrained Array Formula | Ctrl+Shift+Enter | Command+Shift+Enter |
Format
A double asterisk (**) in a cell indicates that the default Mac OS key assignment conflicts with this shortcut. To change your settings, select
Apple > System Preferences > Keyboard > Shortcuts
. Click Mission Control, then clear the shortcut option.Action | Windows | Mac |
|---|---|---|
Clear Formatting (Example: bold text) | Ctrl+\ | Command+\ |
Bold | Ctrl+B | Command+B |
Italic | Ctrl+I | Command+I |
Strikethrough | Ctrl+Shift+X | Command+Shift+X |
Underline | Ctrl+U | Command+U |
Wrap | Alt+W | Option+W |
Center Align | Ctrl+E | Command+E |
Apply Outside Border | Ctrl+Shift+7 | Command+Shift+7 |
Remove Borders | Ctrl+Shift+- | Command+Shift+- |
Default Number | Ctrl+Shift+1 | Command+Shift+1 |
Default Currency | Ctrl+Shift+4 | Command+Shift+4** or Command+Option+4 |
Default Percent | Ctrl+Shift+5 | Command+Shift+5** or Command+Option+5 |
Data
A double asterisk (**) in a cell indicates that the default Mac OS key assignment conflicts with this shortcut. To change your settings, select
Apple > System Preferences > Keyboard > Shortcuts
. Click Mission Control, then clear the shortcut option.Action | Windows | Mac |
|---|---|---|
Show All Formulas | Ctrl+` | Ctrl+` |
Copy Workbook ID | Alt+F3 | Option+F3 |
Recalculate | F9 | F9 |
Recalculate All | Ctrl+Alt+F9 | Command+Option+F9 |
Refresh All Live Data | Ctrl+Alt+F5 or Alt+F1 | Command+Option+F5** or Option+F1 |
Fill from Above Cell | Ctrl+Shift+6 | Alt+F6 |
Fill from Left Cell | Ctrl+Shift+, | Command+Shift+, |
Insert Above Formula | Ctrl+‘ | Command+‘ |
Auto Sum | Alt+= | Option+= |
Enter Current Date | Ctrl+; | Command+; |
Enter Current Time | Ctrl+Shift+; | Command+Shift+; |
Toggle Reference Display | F4 or Ctrl+Alt+T | F4** or Command+Option+T |
Open Prompts in Cell | Alt+Down Arrow | Option+Down Arrow |
Panels
Action | Windows | Mac |
|---|---|---|
Open Versions Panel | Ctrl+F8 | Command+F8 |
Open Chart Panel | Ctrl+F11 | Command+F11 |
Open Comments Panel | Ctrl+F2 | Command+F2 |
Open Context Menu | Shift+F10 | Shift+F10 |
Open Errors Panel | Ctrl+Shift+F1 | Command+Shift+F1 |
Open Formula Editor | Ctrl+F1 | Command+F1 |
Open Functions Library Panel | Ctrl+F9 | Command+F9 |
Open Live Data Panel | Ctrl+F12 | Command+F12 |
Open Defined Names Panel | Ctrl+F3 | Command+F3 |
Open Pivot Table Panel | Ctrl+F7 | Command+F7 |
Open Protected Ranges Panel | Ctrl+F10 | Command+F10 |
Selection
A double asterisk (**) in a cell indicates that the default Mac OS key assignment conflicts with this shortcut. To change your settings, select Apple > System Preferences > Keyboard > Shortcuts. Click Mission Control, then clear the shortcut option.
Action | Windows | Mac |
|---|---|---|
Select to Region Edge | Ctrl+Shift+Arrow | Command+Shift+Arrow |
Select Column | Ctrl+Space or Ctrl+Alt+6 | Command+Space** or Command+Option+6 |
Select Row | Shift+Space | Shift+Space |
Select All | Ctrl+A or Ctrl+Shift+Space | Command+A or Command+Shift+Space |
Extend Selection to Final Cell | Ctrl+Shift+End | Command+Shift+End |
Select Active Cell’s Array | Ctrl+/ | Command+/ |
Select Only Active Cell | Ctrl+Backspace | Command+Backspace |
Hide Selected Rows | Ctrl+Alt+9 | Command+Option+9 |
Hide Selected Columns | Ctrl+Alt+0 | Command+Option+0 |
Unhide Selected Rows | Ctrl+Alt+Shift+9 | Command+Option+Shift+9 |
Unhide Selected Columns | Ctrl+Alt+Shift+0 | Command+Option+Shift+0 |
Open Instance Link Tooltip | Alt+Enter | Option+Enter |