Free Shortcut Cheat Sheets
https://hkeys.app
Home / Apps / Google Sheets

Google Sheets

Google Sheets is a web-based spreadsheet application by Google for data analysis, calculations, and real-time collaboration.

Common actions

Select column
+
Select row
+
Select all
+
A
or
+
+
Undo
+
Z
Redo
+
Y
or
+
+
Z
or
Fn +
F4
Find
+
F
Find and replace
+
+
H
Fill range
+
Fill down
+
D
Fill right
+
R
Save (every change is saved automatically in Drive)
+
S
Open
+
O
Print
+
P
Copy
+
C
Cut
+
X
Paste
+
V
Paste values only
+
+
V
Show common keyboard shortcuts
+
/
Insert new sheet
+
Fn +
F11
Compact controls
+
+
F
Input tools on/off (available in spreadsheets in non-Latin languages)
+
+
K
Select input tools
+
+
+
K
Tool finder (formerly Search the menus)
+
/
Select current region around selected cell
+
+
8
or
+
+
8
Display or hide the menus
+
+
R
or
+
+
F
Convert range to table
+
+
T

Format cells

Bold
+
B
or
+
2
or
+
2
Underline
+
U
or
+
4
or
+
4
Italic
+
I
or
+
3
or
+
3
Strikethrough
+
+
X
or
+
5
or
+
5
Centre align
+
+
E
Left align
+
+
L
Right align
+
+
R
Apply top border
+
+
1
Apply right border
+
+
2
Apply bottom border
+
+
3
Apply left border
+
+
4
Remove borders
+
+
6
Apply outer border
+
+
7
or
+
+
7
or
+
+
7
Insert link
+
K
Insert time
+
+
;
Insert date
+
;
Insert date and time
+
+
+
;
Format as decimal
+
+
1
Format as time
+
+
2
Format as date
+
+
3
Format as currency
+
+
4
Format as percentage
+
+
5
Format as exponent
+
+
6
Clear formatting
+
\

Navigate spreadsheet

Move to beginning of row
Fn +
Move to beginning of sheet
+
Fn +
Move to end of row
Fn +
Move to end of sheet
+
Fn +
Scroll to active cell
+
Move to next sheet
+
or
+
Move to previous sheet
+
or
+
Display list of sheets
+
+
K
Open hyperlink
+
Open Explore
+
+
+
I
Go to side panel
+
+
.
or
+
+
,
Move focus out of spreadsheet
+
+
+
M
Move to quicksum (when a range of cells is selected)
+
+
Q
Move focus to pop-up (for links, bookmarks and images) (Press E, then P holding Ctrl + ⌘)
+
,
E,
P
Open drop-down menu on filtered cell
+
+
R
Open revision history
+
+
+
H
Close drawing editor
+
Esc
or
+
Esc
Show 'Go to range' dialogue
+
G
Find and replace with Find tab selected
+
F

Edit notes and comments

Insert/edit note
+
F2
Insert/edit comment
+
+
M
Open comment discussion thread
+
+
+
A
Enter current comment (Press E, then C holding Ctrl + ⌘)
+
,
E,
C
Move to next comment (Press N, then C holding Ctrl + ⌘)
+
,
N,
C
Move to previous comment (Press P, then C holding Ctrl + ⌘)
+
,
P,
C

Use keyboard shortcuts on selected comments

Reply to current comment
R
Move to next comment
J
Move to previous comment
K
Resolve current comment
E
Exit current comment
U

Open a menu

File menu
+
+
F
Edit menu
+
+
E
View menu
+
+
V
Insert menu
+
+
I
Format menu
+
+
O
Data menu
+
+
D
Tools menu
+
+
T
Open insert menu (with cells selected)
+
+
=
Open delete menu (with cells selected)
+
+
-
Form menu (present when the spreadsheet is connected to a form)
+
+
M
Add-ons menu
+
+
N
Help menu
+
+
H
Accessibility menu (present when screen reader support is enabled)
+
+
A
Sheet menu (copy, delete and other sheet actions)
+
+
S
Context menu
+
+
\
or
+
F10
Table column menu
+
+
\

Add or change rows and columns

Insert rows above (with rows selected)
+
+
=
or
+
+
I,
R,
R
Insert rows below
+
+
I,
R,
B
Insert columns to the left (with columns selected)
+
+
=
or
+
+
I,
C,
C
Insert columns to the right
+
+
I,
C,
O
Delete rows (with rows selected)
+
+
-
or
+
+
E,
D,
D
Delete columns (with columns selected)
+
+
-
or
+
+
E,
D,
E
Hide row
+
+
9
Unhide row
+
+
9
Hide column
+
+
0
Unhide column
+
+
0
Group rows or columns
+
+
Ungroup rows or columns
+
+
Expand grouped rows or columns
+
+
Collapse grouped rows or columns
+
+

Use formulas

Show all formulae
+
`
Insert array formula
+
+
Collapse an expanded array formula
+
E
Show/hide formula help (when entering a formula)
+
Fn +
F1
Full/compact formula help (when entering a formula)
Fn +
F1
Absolute/relative references (when entering a formula)
Fn +
F4
Toggle formula result previews (when entering a formula)
Fn +
F9
Resize formula bar (move up or down)
+
+
or
+
+
Toggle formula range selection (when entering a formula)
F2
or
+
E

Help for screen readers

Turn on screen reader support
+
+
Z
Enable braille support
+
+
H
Read column
+
+
+
C
Read row
+
+
+
R

Why should you learn shortcuts?

Work Twice as Fast
Forget the menus. Shortcuts save seconds — and add up to hours of real time.
Stay in the Flow
Clicks break focus. Shortcuts keep your rhythm steady and ideas moving.
Be a Real Pro
Master your tools. Work with precision, speed, and confidence.
Don’t Fall Behind AI
AI moves at light speed — you can too. Learn shortcuts or stay stuck clicking.
Train Your Brain
Shortcuts boost focus, memory, and reflexes — real digital mental fitness.
More Power, Less Effort
Stay in control. Get more done every day — without burning out or slowing down.