Popular keyboard
shortcuts for Gsheet
Editing
|
|
Undo
|
Ctrl +
Z
|
Insert time
|
Ctrl +
Shift + ;
|
Insert date
|
Ctrl +
;
|
Fill range
|
Ctrl +
Enter
|
Fill down
|
Ctrl +
D
|
Fill right
|
Ctrl +
R
|
Insert/edit note
|
Shift +
F2
|
Insert/edit comment
|
Ctrl +
Alt + M
|
Redo
|
Ctrl +
Y
|
Absolute/relative references
|
F4
|
Input tools on/off
|
Ctrl +
Shift + K
|
Select input tools
|
Ctrl +
Alt + Shift + K
|
Movement
|
|
Move to start of row
|
Home
|
Move to beginning of sheet
|
Ctrl +
Home
|
Move to end of row
|
End
|
Move to end of sheet
|
Ctrl +
End
|
Scroll to active cell
|
Ctrl +
Backspace
|
Move to next sheet
|
Ctrl +
Shift + PageDown
|
Move to previous sheet
|
Ctrl +
Shift + PageUp
|
Find
|
Ctrl +
F
|
Find and replace
|
Ctrl +
H
|
Menus
|
|
Show context menu
|
Ctrl +
Shift + \
|
File Menu
|
Alt + F
|
Edit Menu
|
Alt + E
|
View Menu
|
Alt + V
|
Insert Menu
|
Alt + I
|
Format Menu
|
Alt + O
|
Data Menu
|
Alt + D
|
Form Menu
|
Alt + M
|
Tools Menu
|
Alt + T
|
Add-ons Menu
|
Alt + N
|
Help Menu
|
Alt + H
|
Accessibility Menu
|
Alt + A
|
Show sheet list
|
Alt +
Shift + K
|
Display sheet menu
|
Alt +
Shift + S
|
Formatting
|
|
Bold
|
Ctrl +
B
|
Underline
|
Ctrl +
U
|
Italic
|
Ctrl +
I
|
Strikethrough
|
Alt +
Shift + 5
|
Align center
|
Ctrl +
Shift + E
|
Align left
|
Ctrl +
Shift + L
|
Align right
|
Ctrl +
Shift + R
|
Apply top border
|
Alt +
Shift + 1
|
Apply right border
|
Alt +
Shift + 2
|
Apply bottom border
|
Alt +
Shift + 3
|
Apply left border
|
Alt +
Shift + 4
|
Remove borders
|
Alt +
Shift + 6
|
Apply outer border
|
Alt +
Shift + 7
|
Format as decimal
|
Ctrl +
Shift + 1
|
Format as time
|
Ctrl +
Shift + 2
|
Format as date
|
Ctrl +
Shift + 3
|
Format as currency
|
Ctrl +
Shift + 4
|
Format as percentage
|
Ctrl +
Shift + 5
|
Format as exponent
|
Ctrl +
Shift + 6
|
Selection
|
|
Select column
|
Ctrl +
Space
|
Select row
|
Shift +
Space
|
Select all
|
Ctrl +
A
|
Select active region
|
Ctrl +
Shift + 8
|
Screenreader
|
|
Read column
|
Ctrl +
Alt + Shift + C
|
Read row
|
Ctrl +
Alt + Shift + R
|
Insertion
|
|
Insert array formula
|
Ctrl +
Shift + Enter
|
Add new sheet
|
Shift +
F11
|
File Commands
|
|
Open
|
Ctrl +
O
|
Print
|
Ctrl +
P
|
View
|
|
Show all formulas
|
Ctrl +
`
|
Compact controls
|
Ctrl +
Shift + F
|
Navigation
|
|
Move to top of application
|
Ctrl +
Alt + Shift + M
|
Chat
|
Shift +
Esc
|
Open hyperlink
|
Alt +
Enter
|
Revisions
|
Ctrl +
Alt + Shift + G
|
Focus quicksum
|
Alt +
Shift + Q
|
Focus pop up
|
Ctrl +
Alt + E then Ctrl + Alt + P
|
Open filter dropdown menu
|
Ctrl +
Alt + R
|
Help
|
|
Open documentation (new window)
|
Shift +
F1
|
Show shortcuts help popup
|
Ctrl +
/
|
Enable screen reader support
|
Ctrl +
Alt + Z
|