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
Print	⌘ + 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 ⌘ + Page Down	Alt + Down arrow Ctrl + Page Down
Move to previous sheet	Option + Up arrow ⌘ + Page Up	Alt + Up arrow Ctrl + Page Up

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 + ~