Google Sheets Keyboard Shortcuts — Full Cheat Sheet (Mac & Windows)

Learn Google Sheets keyboard shortcuts just by clicking. 27+ shortcuts, Mac & Windows.

Learn this shortcut without trying

MasterKey is a free Chrome extension. Every time you reach for the mouse in Google Sheets, it shows the shortcut you could have used — so the keys stick without studying.

MasterKey in action: clicking a button in Google Sheets pops up the matching keyboard shortcut

Add to Chrome — it's free

Browse by category

Editing (11)

Copy Cmd+C / Ctrl+C
Paste Cmd+V / Ctrl+V
Paste values only Cmd+Shift+V / Ctrl+Shift+V
Cut Cmd+X / Ctrl+X
Undo Cmd+Z / Ctrl+Z
Redo Cmd+Y / Ctrl+Y
Find and replace Cmd+Shift+H / Ctrl+H
Fill down Cmd+D / Ctrl+D

Formatting (7)

Bold Cmd+B / Ctrl+B
Italic Cmd+I / Ctrl+I
Underline Cmd+U / Ctrl+U
Strikethrough Cmd+Shift+X / Alt+Shift+5
Format as currency Ctrl+Shift+4
Merge all Ctrl+Opt+O → M → A / Alt+O → M → A
Clear formatting Cmd+\ / Ctrl+\

Rows & columns (6)

Insert row above Ctrl+Opt+I → R → R / Alt+I → R → R
Insert column left Ctrl+Opt+I → C → C / Alt+I → C → C
Delete row Cmd+Opt+- / Ctrl+Alt+-
Insert link Cmd+K / Ctrl+K
Insert checkbox Ctrl+Opt+I → X / Alt+I → X
Insert date and time Cmd+Opt+Shift+; / Ctrl+Alt+Shift+;

View (2)

Freeze 1 row Ctrl+Opt+V → R → O / Alt+V → R → O
Show all formulas Ctrl+`

Formulas (1)

Absolute/relative references F4