Office & Documents

Google Sheets Keyboard Shortcuts

246 keyboard shortcuts to help you analyze data in the cloud faster in Google Sheets

Google Sheets keyboard shortcuts

Google Sheets is an office & documents tool from Google that enables users to analyze data in the cloud. It is trusted by creative and technical professionals worldwide.

For Google Sheets users, mastering keyboard shortcuts is one of the fastest ways to boost productivity. Quick access to tools and commands keeps the creative flow unbroken.

macOS Windows Linux
246 shortcuts 12 categories
Visit Google Sheets Official Website
Show shortcuts for:
Jump to Section (12 sections)

General 14 shortcuts

Show common keyboard shortcuts
Cmd +/ Ctrl +/ Ctrl +/
Tool finder (formerly search the menus)
Opt +/ Alt +/ Alt +/
Select all
Cmd +A Ctrl +A Ctrl +A
Select all
Shift +Cmd +Space Ctrl +Shift +Space Ctrl +Shift +Space
Undo
Cmd +Z Ctrl +Z Ctrl +Z
Redo
Shift +Cmd +Z Ctrl +Shift +Z Ctrl +Shift +Z
Redo
Fn +F4 F4 F4
Find
Cmd +F Ctrl +F Ctrl +F
Find and replace
Shift +Cmd +H Ctrl +H Ctrl +H
Compact controls
Shift +Cmd +F Ctrl +Shift +F Ctrl +Shift +F
Insert new sheet
Shift +F11 Shift +F11 Shift +F11
Save (every change is saved automatically in Drive)
Cmd +S Ctrl +S Ctrl +S
Open
Cmd +O Ctrl +O Ctrl +O
Print
Cmd +P Ctrl +P Ctrl +P

Editing 7 shortcuts

Copy
Cmd +C Ctrl +C Ctrl +C
Cut
Cmd +X Ctrl +X Ctrl +X
Paste
Cmd +V Ctrl +V Ctrl +V
Paste values only
Shift +Cmd +V Ctrl +Shift +V Ctrl +Shift +V
Fill range
Cmd +Enter Ctrl +Enter Ctrl +Enter
Fill down
Cmd +D Ctrl +D Ctrl +D
Fill right
Cmd +R Ctrl +R Ctrl +R

Formatting 25 shortcuts

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

Navigation 17 shortcuts

Move to beginning of row
Home Home Home
Move to beginning of sheet
Cmd +Home Ctrl +Home Ctrl +Home
Move to end of row
End End End
Move to end of sheet
Cmd +End Ctrl +End Ctrl +End
Scroll to active cell
Cmd +Backspace Ctrl +Backspace Ctrl +Backspace
Move to next sheet
Opt +Down Alt +Down Alt +Down
Move to previous sheet
Opt +Up Alt +Up Alt +Up
Display list of sheets
Opt +Shift +K Alt +Shift +K Alt +Shift +K
Open hyperlink
Opt +Enter Alt +Enter Alt +Enter
Open Explore
Opt +Shift +Cmd +I Ctrl +Alt +Shift +I Ctrl +Alt +Shift +I
Go to side panel
Opt +Cmd +. Ctrl +Alt +. Ctrl +Alt +.
Go to side panel
Opt +Cmd +, Ctrl +Alt +, Ctrl +Alt +,
Move focus out of spreadsheet
Opt +Shift +Cmd +M Ctrl +Alt +Shift +M Ctrl +Alt +Shift +M
Move to quicksum (when a range of cells is selected)
Opt +Shift +Q Alt +Shift +Q Alt +Shift +Q
Open drop-down menu on filtered cell
Opt +Cmd +R Ctrl +Alt +R Ctrl +Alt +R
Open revision history
Opt +Shift +Cmd +H Ctrl +Alt +Shift +H Ctrl +Alt +Shift +H
Close drawing editor
Shift +Esc Shift +Esc Shift +Esc

Notes and Comments 12 shortcuts

Insert/edit note
Shift +F2 Shift +F2 Shift +F2
Insert/edit comment
Opt +Cmd +M Ctrl +Alt +M Ctrl +Alt +M
Open comment discussion thread
Opt +Shift +Cmd +A Ctrl +Alt +Shift +A Ctrl +Alt +Shift +A
Enter current comment
Ctrl +Cmd +E +C N/A N/A
Move to next comment
Ctrl +Cmd +N +C N/A N/A
Move to previous comment
Ctrl +Cmd +P +C N/A N/A
Insert/edit note
N/A Shift +Search +2 Shift +Search +2
Reply to current comment
N/A R R
Move to next comment
N/A J J
Move to previous comment
N/A K K
Resolve current comment
N/A E E
Exit current comment
N/A U U

Menus 17 shortcuts

File menu
Opt +F Alt +Shift +F Alt +Shift +F
Edit menu
Opt +E Alt +Shift +E Alt +Shift +E
View menu
Opt +V Alt +Shift +V Alt +Shift +V
Insert menu
Opt +I Alt +Shift +I Alt +Shift +I
Format menu
Opt +O Alt +Shift +O Alt +Shift +O
Data menu
Opt +D Alt +Shift +D Alt +Shift +D
Tools menu
Opt +T Alt +Shift +T Alt +Shift +T
Open insert menu
Opt +Cmd += Ctrl +Alt += Ctrl +Alt +=
Open delete menu
Opt +Cmd +- Ctrl +Alt +- Ctrl +Alt +-
Form menu (present when the spreadsheet is connected to a form)
Opt +M Alt +Shift +M Alt +Shift +M
Add-ons menu
Opt +N Alt +Shift +N Alt +Shift +N
Help menu
Opt +H Alt +Shift +H Alt +Shift +H
Accessibility menu (present when screen reader support is enabled)
Opt +A Alt +Shift +A Alt +Shift +A
Sheet menu (copy, delete, and other sheet actions)
Opt +Shift +S Alt +Shift +S Alt +Shift +S
Context menu
Shift +F10 Ctrl +Shift +\\ Ctrl +Shift +\\
Context menu
Shift +F10 Shift +F10 Shift +F10
Table column menu
Opt +Cmd +\\ Ctrl +Alt +\\ Ctrl +Alt +\\

Rows and Columns 20 shortcuts

Insert rows above / Insert columns to the left
Opt +Cmd += Ctrl +Alt += Ctrl +Alt +=
Insert rows below
Opt +I +R +B Alt +Shift +I +R +B Alt +Shift +I +R +B
Insert columns to the right
Opt +I +C +O Alt +Shift +I +C +O Alt +Shift +I +C +O
Delete rows / Delete columns
Opt +Cmd +- Ctrl +Alt +- Ctrl +Alt +-
Insert rows above / Insert rows below / Insert columns to the left / Insert columns to the right
N/A Alt +I Alt +I
Insert rows above / Insert rows below
N/A R R
Insert rows below
N/A B B
Insert columns to the left / Insert columns to the right
N/A C C
Insert columns to the right
N/A O O
Delete rows / Delete columns
N/A Alt +E Alt +E
Delete rows / Delete columns
N/A D D
Delete columns
N/A E E
Hide rows
N/A Ctrl +Alt +9 Ctrl +Alt +9
Unhide rows
N/A Ctrl +Shift +9 Ctrl +Shift +9
Hide columns
N/A Ctrl +Alt +0 Ctrl +Alt +0
Unhide columns
N/A Ctrl +Shift +0 Ctrl +Shift +0
Group rows or columns
N/A Alt +Shift +Right Alt +Shift +Right
Ungroup rows or columns
N/A Alt +Shift +Left Alt +Shift +Left
Expand grouped rows or columns
N/A Alt +Shift +Down Alt +Shift +Down
Collapse grouped rows or columns
N/A Alt +Shift +Up Alt +Shift +Up
The BuildBox Macropad Puts Keyboard Shortcuts at Your Fingertips! Learn More

Common actions 35 shortcuts

Select column
Ctrl +Space Ctrl +Space Ctrl +Space
Select row
Shift +Space Shift +Space Shift +Space
Select all
Cmd +A Ctrl +A Ctrl +A
Select all
Shift +Cmd +Space N/A N/A
Undo
Cmd +Z Ctrl +Z Ctrl +Z
Redo
Cmd +Y Ctrl +Y Ctrl +Y
Redo
Shift +Cmd +Z N/A N/A
Redo
Fn +F4 N/A N/A
Find
Cmd +F Ctrl +F Ctrl +F
Find and replace
Shift +Cmd +H Ctrl +Shift +H Ctrl +Shift +H
Fill range
Cmd +Enter Ctrl +Enter Ctrl +Enter
Fill down
Cmd +D Ctrl +D Ctrl +D
Fill right
Cmd +R Ctrl +R Ctrl +R
Save _(every change is saved automatically in Drive)_
Cmd +S Ctrl +S Ctrl +S
Open
Cmd +O Ctrl +O Ctrl +O
Print
Cmd +P Ctrl +P Ctrl +P
Copy
Cmd +C Ctrl +C Ctrl +C
Cut
Cmd +X Ctrl +X Ctrl +X
Paste
Cmd +V Ctrl +V Ctrl +V
Paste values only
Shift +Cmd +V Ctrl +Shift +V Ctrl +Shift +V
Show common keyboard shortcuts
Cmd +/ Ctrl +/ Ctrl +/
Insert new sheet
Shift +Fn +F11 Shift +F11 Shift +F11
Compact controls / Displays or hides the menus
Ctrl +Shift +F Ctrl +Shift +F Ctrl +Shift +F
Input tools on/off _(available in spreadsheets in non-Latin languages)_
Shift +Cmd +K Ctrl +Shift +K Ctrl +Shift +K
Select input tools
Opt +Shift +Cmd +K N/A N/A
Tool finder _(formerly Search the menus)_
Opt +/ N/A N/A
Select current region around selected cell
Shift +Cmd +* N/A N/A
Select current region around selected cell
Ctrl +Shift +* N/A N/A
Displays or hides the menus
Opt +Cmd +R N/A N/A
Convert range to table
Opt +Cmd +T Ctrl +Alt +T Ctrl +Alt +T
Redo
N/A Ctrl +Shift +Z Ctrl +Shift +Z
Find and replace
N/A Ctrl +H Ctrl +H
Select input tools
N/A Ctrl +Alt +Shift +K Ctrl +Alt +Shift +K
Tool finder _(formerly Search the menus)_
N/A Alt +/ Alt +/
Convert range to table
N/A Alt +Shift +T Alt +Shift +T

Format Cells 37 shortcuts

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

Navigate spreadsheet 40 shortcuts

Move to beginning of row
Fn +Left N/A N/A
Move to beginning of sheet
Cmd +Fn +Left N/A N/A
Move to end of row
Fn +Right N/A N/A
Move to end of sheet
Cmd +Fn +Right N/A N/A
Scroll to active cell
Cmd +Backspace Ctrl +Backspace Ctrl +Backspace
Move to next sheet
Opt +Down N/A N/A
Move to next sheet
Opt +Right N/A N/A
Move to previous sheet
Opt +Up N/A N/A
Move to previous sheet
Opt +Left N/A N/A
Display list of sheets
Opt +Shift +K N/A N/A
Open hyperlink
Opt +Enter Ctrl +Enter Ctrl +Enter
Open Explore
Opt +Shift +Cmd +I Ctrl +Alt +Shift +I Ctrl +Alt +Shift +I
Go to side panel
Opt +Cmd +. Ctrl +Alt +. Ctrl +Alt +.
Go to side panel
Opt +Cmd +, Ctrl +Alt +, Ctrl +Alt +,
Move focus out of spreadsheet
Ctrl +Shift +Cmd +M Ctrl +Shift +M Ctrl +Shift +M
Move to quicksum _(when a range of cells is selected)_
Opt +Shift +Q N/A N/A
Move focus to popup _(for links, bookmarks, and images)_
Ctrl +Cmd +E +P N/A N/A
Open drop-down menu on filtered cell
Ctrl +Cmd +R Ctrl +Shift +R Ctrl +Shift +R
Open revision history
Opt +Shift +Cmd +H Ctrl +Alt +Shift +H Ctrl +Alt +Shift +H
Close drawing editor
Cmd +Esc Esc Esc
Close drawing editor
Shift +Esc N/A N/A
Show "Go to range" dialog
Ctrl +G Ctrl +G Ctrl +G
Find and replace with Find tab selected
Ctrl +F Ctrl +F Ctrl +F
Move to beginning of row
N/A Search +Left Search +Left
Move to end of row
N/A Search +Right Search +Right
Move to first cell in row with data
N/A Ctrl +Left Ctrl +Left
Move to top left of sheet / Move to beginning of sheet
N/A Ctrl +Search +Left Ctrl +Search +Left
Move to last cell in row with data
N/A Ctrl +Right Ctrl +Right
Move to bottom right of sheet / Move to end of sheet
N/A Ctrl +Search +Right Ctrl +Search +Right
Move to next sheet
N/A Ctrl +Shift +Search +Down Ctrl +Shift +Search +Down
Move to previous sheet
N/A Ctrl +Shift +Search +Up Ctrl +Shift +Search +Up
Display list of sheets
N/A Alt +Shift +K Alt +Shift +K
Open hyperlink
N/A Alt +Enter Alt +Enter
Go to side panel
N/A Alt +Shift +. Alt +Shift +.
Go to side panel
N/A Alt +Shift +, Alt +Shift +,
Move focus out of spreadsheet
N/A Ctrl +Alt +Shift +M Ctrl +Alt +Shift +M
Move to quicksum _(when a range of cells is selected)_
N/A Alt +Shift +Q Alt +Shift +Q
Open drop-down menu on filtered cell
N/A Ctrl +Alt +R Ctrl +Alt +R
Close drawing editor
N/A Ctrl +Esc Ctrl +Esc
Close drawing editor
N/A Shift +Esc Shift +Esc

Use keyboard shortcuts on selected comments 5 shortcuts

Reply to current comment
R R R
Move to next comment
J J J
Move to previous comment
K K K
Resolve current comment
E E E
Exit current comment
U U U

Open a menu 17 shortcuts

File menu
N/A Alt +F Alt +F
Edit menu
N/A Alt +E Alt +E
View menu
N/A Alt +V Alt +V
Insert menu
N/A Alt +I Alt +I
Format menu
N/A Alt +O Alt +O
Data menu
N/A Alt +D Alt +D
Tools menu
N/A Alt +T Alt +T
Open insert menu
N/A Ctrl +Alt += Ctrl +Alt +=
Open delete menu
N/A Ctrl +Alt +- Ctrl +Alt +-
Form menu _(present when the spreadsheet is connected to a form)_
N/A Alt +M Alt +M
Add-ons menu
N/A Alt +N Alt +N
Help menu
N/A Alt +H Alt +H
Accessibility menu _(present when screen reader support is enabled)_
N/A Alt +A Alt +A
Sheet menu _(copy, delete, and other sheet actions)_
N/A Ctrl +Shift +S Ctrl +Shift +S
Context menu
N/A Ctrl +Shift +\ Ctrl +Shift +\
Context menu
N/A Shift +F10 Shift +F10
Table column menu
N/A Ctrl +Alt +\ Ctrl +Alt +\
Noticed errors or keyboard shortcuts that don't work? Please let us know about them here
BuildBox Macropad

We've Built 10s Of 1000s Of Keyboard Shortcuts Into The BuildBox Macropad

The BuildBox Macropad is the ultimate shortcut machine. One device with up to 160 configurable shortcuts for apps like Google Sheets available at your fingertips, a crystal clear display showing what every key does, and a hall-effect scroll wheel for scrubbing through video, audio and graphic editing applications like butter!

Drop your email below to be eligible for our first production run of 500 BuildBox units, at a HUGE discount price:

View All Keyboard Shortcuts

Keyboard Shortcuts for Similar Applications