Keyboard shortcuts for Google Sheets

To open a list of keyboard shortcuts in Google Sheets, press Ctrl + / (Windows, Chrome OS) or ⌘ + / (Mac).

You can also use menu access keys. Open any application menu using the keyboard, then type the underlined letter for the item you'd like to select. For example, to open the Insert menu on Chrome OS, press Alt + i. To select "Image," type the underlined letter i.

PC shortcuts

Common actions

Select column Ctrl + Space
Select row Shift + Space
Select all Ctrl + A
Ctrl + Shift + Space
Hide background over selected cells Ctrl + Shift + Backspace
Undo Ctrl + Z
Redo Ctrl + Y
Ctrl + Shift + Z
F4
Find Ctrl + F
Find and replace Ctrl + H
Fill range Ctrl + Enter
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 + Shift + V
Show common keyboard shortcuts Ctrl + /
Insert new sheet Shift + F11
Compact controls Ctrl + Shift + F
Input tools on/off
(available in spreadsheets in non-Latin languages)
Ctrl + Shift + K
Select input tools Ctrl + Alt + Shift + K

Cell formatting

Bold Ctrl + B
Underline Ctrl + U
Italic Ctrl + I
Strikethrough Alt + Shift + 5
Center align Ctrl + Shift + E
Left align Ctrl + Shift + L
Right align 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
Insert link Ctrl + K
Insert time Ctrl + Shift + ;
Insert date Ctrl + ;
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
Clear formatting Ctrl + \

Spreadsheet navigation

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
Scroll to active cell Ctrl + Backspace
Move to next sheet Ctrl + Shift + Page Down
Move to previous sheet Ctrl + Shift + Page Up
Display list of sheets Alt + Shift + K
Open hyperlink Alt + Enter
Move focus out of spreadsheet Ctrl + Alt + Shift + M
Move to quicksum
(when a range of cells is selected)
Alt + Shift + Q
Move focus to popup
(for links, bookmarks, and images)
holding Ctrl + Alt, press E then P
Open drop-down menu on filtered cell Ctrl + Alt + R
Open revision history Ctrl + Alt + Shift + G
Open chat inside the spreadsheet Shift + Esc
Close drawing editor Shift + Esc

Notes and comments

Insert/edit note Shift + F2
Insert/edit comment Ctrl + Alt + M
Open comment discussion thread Ctrl + Alt + Shift + A
Enter current comment holding Ctrl + Alt, press E then C
Move to next comment holding Ctrl + Alt, press N then C
Move to previous comment holding Ctrl + Alt, press P then C

Menus

File menu in Google Chrome: Alt + F
other browsers: Alt + Shift + F
Edit menu in Google Chrome: Alt + E
other browsers: Alt + Shift + E
View menu in Google Chrome: Alt + V
other browsers: Alt + Shift + V
Insert menu in Google Chrome: Alt + I
other browsers: Alt + Shift + I
Format menu in Google Chrome: Alt + O
other browsers: Alt + Shift + O
Data menu in Google Chrome: Alt + D
other browsers: Alt + Shift + D
Tools menu in Google Chrome: Alt + T
other browsers: Alt + Shift + T
Form menu
(present when the spreadsheet is connected to a form)
in Google Chrome: Alt + M
other browsers: Alt + Shift + M
Add-ons menu
(present in the new Google Sheets)
in Google Chrome: Alt + N
other browsers: Alt + Shift + N
Help menu in Google Chrome: Alt + H
other browsers: Alt + Shift + H
Accessibility menu
(present when screen reader support is enabled)
in Google Chrome: Alt + A
other browsers: Alt + Shift + A
Sheet menu
(copy, delete, and other sheet actions)
Alt + Shift + S
Context menu Ctrl + Shift + \

Insert or delete rows or columns

Insert row above in Google Chrome: Alt + I, then R
other browsers: Alt + Shift + I, then R
Insert row below in Google Chrome: Alt + I, then W
other browsers: Alt + Shift + I, then W
Insert column to the left in Google Chrome: Alt + I, then C
other browsers: Alt + Shift + I, then C
Insert column to the right in Google Chrome: Alt + I, then G
other browsers: Alt + Shift + I, then G
Delete row in Google Chrome: Alt + E, then D
other browsers: Alt + Shift + E, then D
Delete column in Google Chrome: Alt + E, then E
other browsers: Alt + Shift + E, then E

Formulas

Show all formulas Ctrl + ~
Insert array formula Ctrl + Shift + Enter
Collapse an expanded array formula Ctrl + E
Show/hide formula help
(when entering a formula)
Shift + F1

Screen reader support

Enable screen reader support
Learn more about using Google Sheets with a screen reader
Ctrl + Alt + Z
Read column Ctrl + Alt + Shift + C
Read row Ctrl + Alt + Shift + R
Mac shortcuts

Common actions

Select column Ctrl + Space
Select row Shift + Space
Select all ⌘ + A
⌘ + Shift + Space
Hide background over selected cells ⌘ + Shift + Backspace
Undo ⌘ + Z
Redo ⌘ + Y
⌘ + Shift + Z
Fn + F4
Find ⌘ + F
Find and replace ⌘ + Shift + H
Fill range ⌘ + Enter
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 ⌘ + Shift + V
Show common keyboard shortcuts ⌘ + /
Compact controls Ctrl + Shift + F
Input tools on/off
(available in spreadsheets in non-Latin languages)
⌘ + Shift + K
Select input tools ⌘ + Option + Shift + K

Cell formatting

Bold ⌘ + B
Underline ⌘ + U
Italic ⌘ + I
Strikethrough Option + Shift + 5
Center align ⌘ + Shift + E
Left align ⌘ + Shift + L
Right align ⌘ + Shift + R
Apply top border Option + Shift + 1
Apply right border Option + Shift + 2
Apply bottom border Option + Shift + 3
Apply left border Option + Shift + 4
Remove borders Option + Shift + 6
Apply outer border Option + Shift + 7
Insert link ⌘ + K
Insert time ⌘ + Shift + ;
Insert date ⌘ + ;
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
Clear formatting ⌘ + \

Spreadsheet navigation

Move to beginning of row Fn + Left arrow
Move to beginning of sheet ⌘ + Fn + Left arrow
Move to end of row Fn + Right arrow
Move to end of sheet ⌘ + Fn + Right arrow
Scroll to active cell ⌘ + Backspace
Move to next sheet ⌘ + Shift + Fn + Down arrow
Move to previous sheet ⌘ + Shift + Fn + Up arrow
Display list of sheets Option + Shift + K
Open hyperlink Option + Enter
Move focus out of spreadsheet Ctrl + ⌘ + Shift + M
Move to quicksum
(when a range of cells is selected)
Option + Shift + Q
Move focus to popup
(for links, bookmarks, and images)
holding Ctrl + ⌘, press E then P
Open drop-down menu on filtered cell Ctrl + ⌘ + R
Open revision history ⌘ + Option + Shift + G
Open chat inside the spreadsheet Shift + Esc
Close drawing editor ⌘ + Esc
Shift + Esc

Notes and comments

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

Menus

File menu Ctrl + Option + F
Edit menu Ctrl + Option + E
View menu Ctrl + Option + V
Insert menu Ctrl + Option + I
Format menu Ctrl + Option + O
Data menu Ctrl + Option + D
Tools menu Ctrl + Option + T
Form menu
(present when the spreadsheet is connected to a form)
Ctrl + Option + M
Add-ons menu
(present in the new Google Sheets)
Ctrl + Option + N
Help menu Ctrl + Option + H
Accessibility menu
(present when screen reader support is enabled)
Ctrl + Option + A
Sheet menu
(copy, delete, and other sheet actions)
Option + Shift + S
Context menu ⌘ + Shift + \

Insert or delete rows or columns

Insert row above Ctrl + Option + I, then R
Insert row below Ctrl + Option + I, then W
Insert column to the left Ctrl + Option + I, then C
Insert column to the right Ctrl + Option + I, then G
Delete row Ctrl + Option + E, then D
Delete column Ctrl + Option + E, then E

Formulas

Show all formulas Ctrl + ~
Insert array formula ⌘ + Shift + Enter
Collapse an expanded array formula ⌘ + E
Show/hide formula help
(when entering a formula)
Shift + Fn + F1

Screen reader support

Enable screen reader support
Learn more about using Google Sheets with a screen reader
⌘ + Option + Z
Read column ⌘ + Option + Shift + C
Read row ⌘ + Option + Shift + R
Chrome OS shortcuts

Common actions

Select column Ctrl + Space
Select row Shift + Space
Select all Ctrl + A
Hide background over selected cells Ctrl + Shift + Backspace
Undo Ctrl + Z
Redo Ctrl + Y
Ctrl + Shift + Z
Find Ctrl + F
Find and replace Ctrl + H
Fill range Ctrl + Enter
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 + Shift + V
Show common keyboard shortcuts Ctrl + /
Compact controls Ctrl + Shift + F
Input tools on/off
(available in spreadsheets in non-Latin languages)
Ctrl + Shift + K
Select input tools Ctrl + Alt + Shift + K

Cell formatting

Bold Ctrl + B
Underline Ctrl + U
Italic Ctrl + I
Strikethrough Alt + Shift + 5
Center align Ctrl + Shift + E
Right align 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
Insert link Ctrl + K
Insert time Ctrl + Shift + ;
Insert date Ctrl + ;
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
Clear formatting Ctrl + \

Spreadsheet navigation

Move to beginning of row Ctrl + Left arrow
Move to beginning of sheet Ctrl + Search + Left arrow
Move to end of row Ctrl + Right arrow
Move to end of sheet Ctrl + Search + Right arrow
Scroll to active cell Ctrl + Backspace
Display list of sheets Alt + Shift + K
Open hyperlink Alt + Enter
Move focus out of spreadsheet Ctrl + Alt + Shift + M
Move to quicksum
(when a range of cells is selected)
Alt + Shift + Q
Move focus to popup
(for links, bookmarks, and images)
holding Ctrl + Alt, press E then P
Open drop-down menu on filtered cell Ctrl + Alt + R
Open revision history Ctrl + Alt + Shift + G
Open chat inside the spreadsheet Shift + Esc
Close drawing editor Ctrl + Esc
Shift + Esc

Notes and comments

Insert/edit note Shift + Search + 2
Insert/edit comment Ctrl + Alt + M
Open comment discussion thread Ctrl + Alt + Shift + A
Enter current comment holding Ctrl + Alt, press E then C

Menus

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
Form menu
(present when the spreadsheet is connected to a form)
Alt + M
Add-ons menu
(present in the new Google Sheets)
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 + Shift + S
Context menu Ctrl + Shift + \

Insert or delete rows or columns

Insert row above Alt + I, then R
Insert row below Alt + I, then W
Insert column to the left Alt + I, then C
Insert column to the right Alt + I, then G
Delete row Alt + E, then D
Delete column Alt + E, then E

Formulas

Show all formulas Ctrl + ~
Insert array formula Ctrl + Shift + Enter
Collapse an expanded array formula Ctrl + E
Show/hide formula help
(when entering a formula)
Shift + Search + 1

Screen reader support

Enable screen reader support
Learn more about using Google Sheets with a screen reader
Ctrl + Alt + Z
Read column Ctrl + Alt + Shift + C
Read row Ctrl + Alt + Shift + R
Android shortcuts

Common actions

Copy Ctrl + C
Cut Ctrl + X
Paste Ctrl + V
Undo Ctrl + Z
Redo Ctrl + Y
Ctrl + Shift + Z
Exit and cancel cell editing Esc
Ctrl + ~
Edit cell Enter
Find and replace Ctrl + F
Ctrl + H
Delete cell or selected range Backspace
Delete character to the left
(when editing cell)
Backspace
Delete character to the right
(when editing cell)
Shift + Backspace
Print Ctrl + P

Cell formatting

Bold Ctrl + B
Underline Ctrl + U
Italic Ctrl + I
Strikethrough Alt + Shift + 5
Center align Ctrl + Shift + E
Left align Ctrl + Shift + L
Right align Ctrl + Shift + R
Insert date Ctrl + ;
Insert time Ctrl + Shift + ;
Clear formatting Ctrl + \

Navigation and selection

Move around the grid Arrow keys
Jump to the beginning/end of a section Ctrl + Arrow keys
Select a range Shift + Arrow keys
Select all Ctrl + A
Select row Shift + Space
Select one character at a time
(when editing cell)
Shift + Left/right arrow keys
Open menu for additional options Ctrl + +
Some shortcuts might not work for all languages or keyboard formats.

Matt is a Docs & Drive expert and author of this help page. Leave him feedback below about the page.

Was this article helpful?