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 (Windows)

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

+ 4 more controls in the table below

48 shortcuts

Editing 17

Action Shortcut
Undo CtrlZ
Copy CtrlC
Paste CtrlV
Redo CtrlY
Cut CtrlX
Find CtrlF
Paste values only CtrlShiftV
Find and replace CtrlH
Fill range CtrlEnter
Fill down CtrlD
Fill right CtrlR
Insert link CtrlK
Insert date Ctrl;
Insert time CtrlShift;
Insert/edit comment CtrlAltM
Print CtrlP
Insert/edit note ShiftF2

Formatting 12

Action Shortcut
Bold CtrlB
Italic CtrlI
Underline CtrlU
Center align CtrlShiftE
Clear formatting Ctrl\
Strikethrough AltShift5
Left align CtrlShiftL
Right align CtrlShiftR
Format as percentage CtrlShift5
Format as currency CtrlShift4
Format as date CtrlShift3
Apply outer border AltShift7

Navigation 7

Action Shortcut
Move to beginning of row Home
Move to end of row End
Move to beginning of sheet CtrlHome
Move to end of sheet CtrlEnd
Next sheet Alt↓
Previous sheet Alt↑
Open hyperlink AltEnter

Rows & Columns 6

Action Shortcut
Insert rows above CtrlAlt=
Delete rows CtrlAlt−
Hide row CtrlAlt9
Unhide row CtrlShift9
Hide column CtrlAlt0
Unhide column CtrlShift0

Selection 3

Action Shortcut
Select all CtrlA
Select column CtrlSpace
Select row ShiftSpace

Formulas 3

Action Shortcut
Toggle absolute/relative reference F4
Show all formulas Ctrl`
Insert array formula CtrlShiftEnter

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

Windows edition · 48 shortcuts

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

Edition
Apple Mac Windows Windows

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 Windows — 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 Windows 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