Ctrl + Space
|
Common actions
Select column
|
↑ Shift + Space
|
Common actions
Select row
|
Ctrl + A
|
Common actions
Select all
|
Ctrl + ↑ Shift + Space
|
Common actions
Select all
|
Ctrl + Z
|
Common actions
Undo
|
Ctrl + Y
|
Common actions
Redo
|
Ctrl + ↑ Shift + Z
|
Common actions
Redo
|
F4
|
Use formulas
(when entering a formula) Absolute/relative references
|
Ctrl + F
|
Common actions
Find
|
Ctrl + H
|
Common actions
Find and replace
|
Ctrl + ⤶ Enter
|
Common actions
Fill range
|
Ctrl + D
|
Common actions
Fill down
|
Ctrl + R
|
Common actions
Fill right
|
Ctrl + S
|
Common actions
Save (every change is saved automatically in Drive)
|
Ctrl + O
|
Common actions
Open
|
Ctrl + P
|
Common actions
Print
|
Ctrl + C
|
Common actions
Copy
|
Ctrl + X
|
Common actions
Cut
|
Ctrl + V
|
Common actions
Paste
|
Ctrl + ↑ Shift + V
|
Common actions
Paste values only
|
Ctrl + /
|
Common actions
Show common keyboard shortcuts
|
↑ Shift + F11
|
Common actions
Insert new sheet
|
Ctrl + ↑ Shift + F
|
Common actions
Compact controls
|
Ctrl + ↑ Shift + K
|
Common actions
Input tools on/off (available in spreadsheets in non-Latin languages)
|
Ctrl + Alt + ↑ Shift + K
|
Common actions
Select input tools
|
Ctrl + B
|
Format cells
Bold
|
Ctrl + U
|
Format cells
Underline
|
Ctrl + İ
|
Format cells
Italic
|
Alt + ↑ Shift + 5
|
Format cells
Strikethrough
|
Ctrl + ↑ Shift + E
|
Format cells
Center align
|
Ctrl + ↑ Shift + L
|
Format cells
Left align
|
Ctrl + ↑ Shift + R
|
Format cells
Right align
|
Alt + ↑ Shift + 1
|
Format cells
Apply top border
|
Alt + ↑ Shift + 2
|
Format cells
Apply right border
|
Alt + ↑ Shift + 3
|
Format cells
Apply bottom border
|
Alt + ↑ Shift + 4
|
Format cells
Apply left border
|
Alt + ↑ Shift + 6
|
Format cells
Remove borders
|
Alt + ↑ Shift + 7
|
Format cells
Apply outer border
|
Ctrl + ↑ Shift + 7
|
Format cells
Apply outer border
|
Ctrl + K
|
Format cells
Insert link
|
Ctrl + ↑ Shift + ;
|
Format cells
Insert time
|
Ctrl + ;
|
Format cells
Insert date
|
Ctrl + Alt + ↑ Shift + ;
|
Format cells
Insert date and time
|
Ctrl + ↑ Shift + 1
|
Format cells
Format as decimal
|
Ctrl + ↑ Shift + 2
|
Format cells
Format as time
|
Ctrl + ↑ Shift + 3
|
Format cells
Format as date
|
Ctrl + ↑ Shift + 4
|
Format cells
Format as currency
|
Ctrl + ↑ Shift + 5
|
Format cells
Format as percentage
|
Ctrl + ↑ Shift + 6
|
Format cells
Format as exponent
|
Ctrl + \
|
Format cells
Clear formatting
|
Home
|
Navigate spreadsheet
Move to beginning of row
|
Ctrl + Home
|
Navigate spreadsheet
Move to beginning of sheet
|
End
|
Navigate spreadsheet
Move to end of row
|
Ctrl + End
|
Navigate spreadsheet
Move to end of sheet
|
Ctrl + ⬅ Backspace
|
Navigate spreadsheet
Scroll to active cell
|
Ctrl + Shift + Page Down
|
Navigate spreadsheet
Move to next sheet
|
Ctrl + Shift + Page Up
|
Navigate spreadsheet
Move to previous sheet
|
Alt + ↑ Shift + K
|
Navigate spreadsheet
Display list of sheets
|
Alt + ⤶ Enter
|
Navigate spreadsheet
Open hyperlink
|
Alt + ↑ Shift + X
|
Navigate spreadsheet
Open Explore
|
Ctrl + Alt + ↑ Shift + M
|
Navigate spreadsheet
Move focus out of spreadsheet
|
Alt + ↑ Shift + Q
|
Navigate spreadsheet
Move to quicksum (when a range of cells is selected)
|
Ctrl + Alt then E then P
|
Navigate spreadsheet
Move focus to popup (for links, bookmarks, and images)
|
Ctrl + Alt + R
|
Navigate spreadsheet
Open drop-down menu on filtered cell
|
Ctrl + Alt + ↑ Shift + H
|
Navigate spreadsheet
Open revision history
|
↑ Shift + Esc
|
Navigate spreadsheet
Close drawing editor
|
↑ Shift + F2
|
Edit notes and comments
Insert/edit note
|
Ctrl + Alt + M
|
Edit notes and comments
Insert/edit comment
|
Ctrl + Alt + ↑ Shift + A
|
Edit notes and comments
Open comment discussion thread
|
Ctrl + Alt then E then C
|
Edit notes and comments
Enter current comment
|
Ctrl + Alt then N then C
|
Edit notes and comments
Move to next comment
|
Ctrl + Alt then P then C
|
Edit notes and comments
Move to previous comment
|
Alt + F
|
Open a menu
(in Google Chrome) File menu
|
Alt + ↑ Shift + F
|
Open a menu
(in other browsers) File menu
|
Alt + E
|
Open a menu
(in Google Chrome) Edit menu
|
Alt + ↑ Shift + E
|
Open a menu
(in other browsers) Edit menu
|
Alt + V
|
Open a menu
(in Google Chrome) View menu
|
Alt + ↑ Shift + V
|
Open a menu
View menu (in other browsers)
|
Alt + I
|
Open a menu
(in Google Chrome) Insert menu
|
Alt + ↑ Shift + İ
|
Open a menu
(in other browsers) Insert menu
|
Alt + O
|
Open a menu
Format menu (in Google Chrome)
|
Alt + ↑ Shift + O
|
Open a menu
(in other browsers) Format menu
|
Alt + D
|
Open a menu
Data menu (in Google Chrome)
|
Alt + ↑ Shift + D
|
Open a menu
(in other browsers)
|
Alt + T
|
Open a menu
Tools menu (in Google Chrome)
|
Alt + ↑ Shift + T
|
Open a menu
(in other browsers)
|
Ctrl + Alt + ↑ Shift + =
|
Insert, delete, hide, or unhide rows or columns
(with columns selected) Insert columns to the left
|
Ctrl + Alt + =
|
Insert, delete, hide, or unhide rows or columns
(with columns selected) Insert columns to the left
|
Ctrl + Alt + -
|
Insert, delete, hide, or unhide rows or columns
(with columns selected) Delete columns
|
Alt + M
|
Open a menu
(in Google Chrome) Form menu
|
Alt + ↑ Shift + M
|
Open a menu
(other browsers. Present when the spreadsheet is connected to a form) Form menu
|
Alt + N
|
Open a menu
(in Google Chrome) Add-ons menu
|
Alt + ↑ Shift + N
|
Open a menu
(in other browsers) Add-ons menu
|
Alt + H
|
Open a menu
(in Google Chrome) Help menu
|
Alt + ↑ Shift + H
|
Open a menu
(in other browsers) Help menu
|
Alt + A
|
Open a menu
(in Google Chrome) Accessibility menu
|
Alt + ↑ Shift + A
|
Open a menu
(in other browsers. Present when screen reader support is enabled) Accessibility menu
|
Alt + ↑ Shift + S
|
Open a menu
Sheet menu (copy, delete, and other sheet actions)
|
Ctrl + ↑ Shift + \
|
Open a menu
Context menu
|
Alt + I then R
|
Insert, delete, hide, or unhide rows or columns
(in Google Chrome) Insert rows above
|
Alt + ↑ Shift + I then R
|
Insert, delete, hide, or unhide rows or columns
(in other browsers) Insert rows above
|
Alt + I then W
|
Insert, delete, hide, or unhide rows or columns
(in Google Chrome) Insert rows below
|
Alt + ↑ Shift + I then W
|
Insert, delete, hide, or unhide rows or columns
(in other browsers) Insert rows below
|
Alt + I then C
|
Insert, delete, hide, or unhide rows or columns
(in Google Chrome, with columns selected) Insert columns to the left
|
Alt + ↑ Shift + I then C
|
Insert, delete, hide, or unhide rows or columns
(in other browsers, with columns selected) Insert columns to the left
|
Alt + I then O
|
Insert, delete, hide, or unhide rows or columns
(in Google Chrome) Insert columns to the right
|
Alt + ↑ Shift + I then O
|
Insert, delete, hide, or unhide rows or columns
(in other browsers) Insert columns to the right
|
Alt + E then D
|
Insert, delete, hide, or unhide rows or columns
(in Google Chrome, with rows selected) Delete rows
|
Alt + ↑ Shift + E then D
|
Insert, delete, hide, or unhide rows or columns
(in other browsers, with rows selected) Delete rows
|
Alt + E then E
|
Insert, delete, hide, or unhide rows or columns
(in Google Chrome, with columns selected) Delete columns
|
Alt + ↑ Shift + E then E
|
Insert, delete, hide, or unhide rows or columns
(in Google Chrome, with columns selected) Delete columns
|
Ctrl + Alt + 9
|
Insert, delete, hide, or unhide rows or columns
Hide row
|
Ctrl + Alt + 0
|
Insert, delete, hide, or unhide rows or columns
Hide column
|
Ctrl + ↑ Shift + 9
|
Insert, delete, hide, or unhide rows or columns
Unhide row
|
Ctrl + ↑ Shift + 0
|
Insert, delete, hide, or unhide rows or columns
Unhide column
|
Ctrl + ~
|
Use formulas
Show all formulas
|
Ctrl + ↑ Shift + ⤶ Enter
|
Use formulas
Insert array formula
|
Ctrl + E
|
Use formulas
Collapse an expanded array formula
|
↑ Shift + F1
|
Use formulas
(when entering a formula) Show/hide formula help
|
F9
|
Use formulas
(when entering a formula) Toggle formula result previews
|
Ctrl + ↑ ↓
|
Use formulas
Resize formula bar
|
Ctrl + Alt + Z
|
Help for screen readers
Turn on screen reader support
|
Ctrl + Alt + ↑ Shift + C
|
Help for screen readers
Read column
|
Ctrl + Alt + ↑ Shift + R
|
Help for screen readers
Read row
|