Hotkey Training App
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.
Windows
macOS
iOS
Android
ChromeOS
Full
Short
Icon
Common actions
Select column
Ctrl
+
Select row
+
Select all
Ctrl
+
A
or
Ctrl
+
+
Undo
Ctrl
+
Z
Redo
Ctrl
+
Y
or
Ctrl
+
+
Z
or
F4
Find
Ctrl
+
F
Find and replace
Ctrl
+
H
Fill range
Ctrl
+
Fill down
Ctrl
+
D
Fill right
Ctrl
+
R
Print
Ctrl
+
P
Copy
Ctrl
+
C
Cut
Ctrl
+
X
Paste
Ctrl
+
V
Paste values only
Ctrl
+
+
V
Paste format only
Ctrl
+
Alt
+
V
Show common keyboard shortcuts
Ctrl
+
/
Insert new sheet
Ctrl
+
T
or
+
F11
Move to sheet at index #
Ctrl
+
[1-9]
Open
Ctrl
+
O
Zoom in
Ctrl
+
.
Zoom out
Ctrl
+
,
Zoom 100%
+
Alt
+
0
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 automatic
Ctrl
+
+
'
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
+
\
Insert rows (with rows selected)
Ctrl
+
Alt
+
=
or
Ctrl
+
+
Alt
+
=
Insert columns (with columns selected)
Ctrl
+
Alt
+
=
or
Ctrl
+
+
Alt
+
=
Delete rows (with rows selected)
Ctrl
+
Alt
+
-
Delete columns (with columns selected)
Ctrl
+
Alt
+
-
Hide row
Ctrl
+
Alt
+
9
Unhide row
Ctrl
+
+
9
Hide column
Ctrl
+
Alt
+
0
Unhide column
Ctrl
+
+
0
Group rows or columns
+
Alt
+
Ungroup rows or columns
+
Alt
+
Expand grouped rows or columns
+
Alt
+
Collapse grouped rows or columns
+
Alt
+
Navigate spreadsheet
Move to section boundary
Ctrl
+
or
Ctrl
+
or
Ctrl
+
or
Ctrl
+
Select from current position to section boundary
Ctrl
+
+
or
Ctrl
+
+
or
Ctrl
+
+
or
Ctrl
+
+
Scroll to active cell
Ctrl
+
Move to next sheet
Alt
+
or
Ctrl
+
+
Pg Dn
Move to previous sheet
Alt
+
or
Ctrl
+
+
Pg Up
Display list of sheets
+
Alt
+
K
Open hyperlink
Alt
+
Open Explore
+
Alt
+
X
Open menu on filtered cell
Ctrl
+
+
Alt
+
R
or
Ctrl
+
Alt
+
R
Move to beginning of row
Home
Move to beginning of sheet
Ctrl
+
Home
Move to end of row
End
Move to end of sheet
Ctrl
+
End
Edit notes and comments
Insert/edit note
+
F2
Insert/edit comment
Ctrl
+
Alt
+
M
Open comment discussion thread
Ctrl
+
+
Alt
+
A
Open a menu
Insert menu
Alt
+
I
Format menu
Alt
+
O
Sheet menu (copy, delete and other sheet actions)
+
Alt
+
S
Context menu
Ctrl
+
+
\
or
+
F10
or
Alt
+
or
Right-click
Use formulas
Insert array formula
Ctrl
+
+
Show expanded function help (when entering a formula)
F1
Toggle formula range selection (when entering a formula)
F2
or
Ctrl
+
E
Absolute/relative range references (when entering a formula)
F4
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.