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
Ctrl +
Select row
+
Select all
Ctrl +
A
Undo
Ctrl +
Z
Redo
Ctrl +
+
Z
or
Ctrl +
Y
Find
Ctrl +
F
Find and replace
Ctrl +
H
Fill range
Ctrl +
Fill down
Ctrl +
D
Fill right
Ctrl +
R
Save (every change is saved automatically in Drive)
Ctrl +
S
Open
Ctrl +
O
Print
Ctrl +
P
Copy
Ctrl +
C
Cut
Ctrl +
X
Paste
Ctrl +
V
Paste values only
Ctrl +
+
V
Show common keyboard shortcuts
Ctrl +
/
Compact controls
Ctrl +
+
F
Input tools on/off (available in spreadsheets in non-Latin languages)
Ctrl +
+
K
Select input tools
Ctrl +
+
Alt +
K
Tool finder (formerly Search the menus)
Alt +
/
Convert range to table
+
Alt +
T

Format cells

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

Navigate spreadsheet

Move to beginning of row
+
Move to end of row
+
Move to first cell in row with data
Ctrl +
Move to top left of sheet
Ctrl +
+
Move to last cell in row with data
Ctrl +
Move to bottom right of sheet
Ctrl +
+
Scroll to active cell
Ctrl +
Move to beginning of sheet
Ctrl +
+
Move to end of sheet
Ctrl +
+
Move to next sheet
Ctrl +
+
+
Move to previous sheet
Ctrl +
+
+
Display list of sheets
+
Alt +
K
Open hyperlink
Alt +
Open Explore
Ctrl +
+
Alt +
I
Go to side panel
+
Alt +
.
or
+
Alt +
,
Move focus out of spreadsheet
Ctrl +
+
Alt +
M
Move to quicksum (when a range of cells is selected)
+
Alt +
Q
Move focus to pop-up (for links, bookmarks and images) (Press E, then P holding Ctrl + Alt)
Ctrl +
Alt,
E,
P
Open drop-down menu on filtered cell
Ctrl +
Alt +
R
Open revision history
Ctrl +
+
Alt +
H
Close drawing editor
Ctrl +
Esc
or
+
Esc

Edit notes and comments

Insert/edit note
+
+
2
Insert/edit comment
Ctrl +
Alt +
M
Open comment discussion thread
Ctrl +
+
Alt +
A
Enter current comment (Press E, then C holding Ctrl + Alt)
Ctrl +
Alt,
E,
C
Move to next comment (Press N, then C holding Ctrl + Alt)
Ctrl +
Alt,
N,
C
Move to previous comment (Press P, then C holding Ctrl + Alt)
Ctrl +
Alt,
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
Alt +
F
Edit menu
Alt +
E
View menu
Alt +
V
Insert menu
Alt +
I
Format menu
Alt +
O
Data menu
Alt +
D
Tools menu
Alt +
T
Open insert menu (with cells selected)
Ctrl +
Alt +
=
Open delete menu (with cells selected)
Ctrl +
Alt +
-
Form menu (present when the spreadsheet is connected to a form)
Alt +
M
Add-ons menu
Alt +
N
Help menu
Alt +
H
Accessibility menu (present when screen reader support is enabled)
Alt +
A
Sheet menu (copy, delete and other sheet actions)
Ctrl +
+
S
Context menu
Ctrl +
+
\
or
+
F10
Table column menu
Ctrl +
Alt +
\

Add or change rows and columns

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

Use formulas

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

Help for screen readers

Turn on screen reader support
Ctrl +
Alt +
Z
Enable braille support
Ctrl +
Alt +
H
Read column
Ctrl +
+
Alt +
C
Read row
Ctrl +
+
Alt +
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.