Keyboard shortcuts
Use keyboard shortcuts to navigate, format and use formulas.
Common actions
| Description | Mac shortcut | Windows shortcut |
|---|---|---|
Select column | Ctrl + Space | Ctrl + Space |
Select row | Shift + Space | Shift + Space |
Select all | ⌘ + A ⌘ + Shift + Space | Ctrl + A Ctrl + Shift + Space |
Undo | ⌘ + Z | Ctrl + Z |
Redo | ⌘ + Y ⌘ + Shift + Z | Ctrl + Y Ctrl + Shift + Z |
Find | ⌘ + F | Ctrl + F |
Fill range | ⌘ + Enter | Ctrl + Enter |
Fill down | ⌘ + D | Ctrl + D |
Fill right | ⌘ + R | Ctrl + R |
⌘ + P | Ctrl + P | |
Copy | ⌘ + C | Ctrl + C |
Cut | ⌘ + X | Ctrl + X |
Paste | ⌘ + V | Ctrl + V |
Paste values only | ⌘ + Shift + V | Ctrl + Shift + V |
Insert new sheet | Shift + F11 | Shift + F11 |
Clear selected cell | Backspace or Delete | Backspace or Delete |
Format Cells
| Description | Mac shortcut | Windows shortcut |
|---|---|---|
Bold | ⌘ + b | Cltr + B |
Underline | ⌘ + U | Cltr + U |
Italic | ⌘ + I | Cltr + I |
Strikethrough | ⌘ + Shift + X | Cltr + Shift + X |
Centre align | ⌘ + Shift + E | Ctrl + Shift + E |
Left align | ⌘ + Shift + L | Ctrl + Shift + L |
Right align | ⌘ + Shift + R | Ctrl + Shift + R |
Apply top border | Alt + Shift + 1 | Option + Shift + 1 |
Apply right border | Alt + Shift + 2 | Option + Shift + 2 |
Apply bottom border | Alt + Shift + 3 | Option + Shift + 3 |
Apply left border | Alt + Shift + 4 | Option + Shift + 4 |
Remove borders | Alt + Shift + 6 | Option + Shift + 6 |
Apply outer border | Alt + Shift + 7 | Option + Shift + 7 |
Insert time | ⌘ + Shift + ; | Ctrl + Shift + ; |
Insert date | ⌘ + ; | Ctrl + ; |
Insert date and time | ⌘ + Option + Shift + ; | Ctrl + Alt + Shift + ; |
Format as decimal | Ctrl + Shift + 1 | Ctrl + Shift + 1 |
Format as time | Ctrl + Shift + 2 | Ctrl + Shift + 2 |
Format as date | Ctrl + Shift + 3 | Ctrl + Shift + 3 |
Format as currency | Ctrl + Shift + 4 | Ctrl + Shift + 4 |
Format as percentage | Ctrl + Shift + 5 | Ctrl + Shift + 5 |
Format as exponent (TBD) | Ctrl + Shift + 6 | Ctrl + Shift + 6 |
Clear formatting | ⌘ + \ | Ctrl + \ |
Show format dialog | ⌘ + Option + 1 | Ctrl + Alt + 1| |
Navigate spreadsheet
| Description | Mac shortcut | Windows shortcut |
|---|---|---|
Move to beginning of row | Fn + Left arrow | Home |
Move to beginning of sheet | ⌘ + Fn + Left arrow | Ctrl + Home |
Move to end of row | Fn + Right arrow | End |
Move to end of sheet | ⌘ + Fn + Right arrow | Ctrl + End |
Scroll to active cell | ⌘ + Backspace | Ctrl + Backspace |
Move to next sheet | Option + Down arrow | Alt + Down arrow |
Move to previous sheet | Option + Up arrow | Alt + Up arrow |
Edit notes
| Description | Mac shortcut | Windows shortcut |
|---|---|---|
Insert/edit note | Shift + F2 | Shift + F2 |
Open menu
| Description | Mac shortcut | Windows shortcut |
|---|---|---|
Context menu | Shift + F10 | Shift + F10 |
Add or change rows and columns
| Description | Mac shortcut | Windows shortcut |
|---|---|---|
Insert rows above | ||
Insert rows below | ||
Insert columns to the left | ||
Insert columns to the right | ||
Delete rows | ||
Delete columns | ||
Hide row | ⌘ + Option + 9 | Ctrl + Alt + 9 |
Hide column | ⌘ + Option + 0 | Ctrl + Alt + 0 |
Use formulas
| Description | Mac shortcut | Windows shortcut |
|---|---|---|
Show all formulae | Ctrl + ~ | Ctrl + ~ |
Last updated