ShortcutPosters
iPhone appNew

Google Sheets Keyboard shortcuts

Get the poster

Google Sheets is a cloud-based spreadsheet app for analyzing data, building formulas, and collaborating on tables live. Its keyboard shortcuts power fast cell navigation, formatting, and entry, which is essential when crunching large sheets.

All Google Sheets keyboard shortcuts (Mac)

Layout
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
⌫
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
⇪
A
S
D
F
G
H
J
K
L
;
'
↩
Shift
Z
X
C
V
B
N
M
,
.
/
Shift
⌃
⌘
⌥
Space
⌥
⌘
⌃
↑
←
↓
→

48 shortcuts

Editing 17

Action Shortcut
Undo ⌘Z
Copy ⌘C
Paste ⌘V
Redo ⌘Y
Cut ⌘X
Find ⌘F
Paste values only ⌘⇧V
Find and replace ⌘⇧H
Fill range ⌘↵
Fill down ⌘D
Fill right ⌘R
Insert link ⌘K
Insert date ⌘;
Insert time ⌘⇧;
Insert/edit comment ⌘⌥M
Print ⌘P
Insert/edit note ⇧F2

Formatting 12

Action Shortcut
Bold ⌘B
Italic ⌘I
Underline ⌘U
Center align ⌘⇧E
Clear formatting ⌘\
Strikethrough ⌘⇧X
Left align ⌘⇧L
Right align ⌘⇧R
Format as percentage ⌃⇧5
Format as currency ⌃⇧4
Format as date ⌃⇧3
Apply outer border ⌥⇧7

Navigation 7

Action Shortcut
Move to beginning of row Fn←
Move to end of row Fn→
Move to beginning of sheet ⌘Fn←
Move to end of sheet ⌘Fn→
Next sheet ⌥↓
Previous sheet ⌥↑
Open hyperlink ⌥↵

Rows & Columns 6

Action Shortcut
Insert rows above ⌘⌥=
Delete rows ⌘⌥−
Hide row ⌘⌥9
Unhide row ⌘⇧9
Hide column ⌘⌥0
Unhide column ⌘⇧0

Selection 3

Action Shortcut
Select all ⌘A
Select column ⌃␣
Select row ⇧␣

Formulas 3

Action Shortcut
Toggle absolute/relative reference FnF4
Show all formulas ⌃`
Insert array formula ⌘⇧↵

Sourced from support.google.com Last verified

Unofficial reference. ShortcutPosters is not affiliated with, endorsed by, or sponsored by Google Sheets. All product names, logos, and trademarks are property of their respective owners. See our licensing & trademark notice.

Get the Google Sheets poster

5 art directions — pick one below, click to zoom & compare.

Google Sheets block shortcuts poster preview
Google Sheets aurora shortcuts poster preview
Google Sheets studio shortcuts poster preview
Google Sheets blueprint shortcuts poster preview
Google Sheets riso shortcuts poster preview

Mac edition · 48 shortcuts

A printable, framed-quality poster of the essential Google Sheets shortcuts for Mac — the keys worth keeping in view, designed to stay readable on a wall.

Edition

Free PNG is web-resolution & watermarked.

Customise this poster Pick the shortcuts, restyle the colours — download free. Get the framed-quality print Full 300 DPI, print-ready — at home or shipped to your door.

Frequently asked questions

Does the poster include every Google Sheets shortcut?
Google Sheets has 48 keyboard shortcuts on macOS — the complete list is free to read on this page. The poster features the most essential ones, curated to stay readable on a wall.
Can I print it at home?
Yes. The digital download is a high-resolution 300 DPI file you can print at home or at any print shop, in standard frame sizes.
Does it cover both Mac and Windows?
We sell a separate edition per platform so every key matches your keyboard exactly. This page is the macOS edition.
Is this an official Google Sheets product?
No. This is an unofficial reference poster and is not affiliated with or endorsed by Google Sheets. All trademarks belong to their respective owners.

Guides

Promote your app

Built an app with great keyboard shortcuts? Get it into the database — a free, searchable reference page, and an optional printable poster your power users will pin to the wall.

  • Free shortcut reference page
  • Indexed & searchable
  • Optional framed poster