Use keyboard shortcuts in Google Sheets to navigate, format, and use formulas.
Note: Some shortcuts might not work for all languages or keyboards.
To see a list of keyboard shortcuts in Google Sheets, press Ctrl+ /(Windows, Chrome OS) or ⌘+ /(Mac).
Tool finder (formerly search the menus), press Alt+ /(Windows, Chrome OS) or Option+ /(Mac).
PC shortcuts
Common actions
Select column
Ctrl+ Space
Select row
Shift+ Space
Select all
Ctrl+ a
Ctrl+ Shift+ Space
Ctrl+ Shift+ Space
Undo
Ctrl+ z
Redo
Ctrl+ y
Ctrl+ Shift+ z
F4
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)
(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)
(available in spreadsheets in non-Latin languages)
Ctrl+ Shift+ k
Select input tools
Ctrl+ Alt+ Shift+ k
Tool finder (formerly Search the menus)
Alt+ /
Rename sheet
Alt+ 1
Convert range to table
Ctrl+ Alt+ T
Format cells
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
Ctrl+ Shift+ 7
Insert link
Ctrl+ k
Insert time
Ctrl+ Shift+ ;
Insert date
Ctrl+ ;
Insert date and time
Ctrl+ Alt+ Shift+ ;
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+ \
Navigate spreadsheet
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
Alt+ Down Arrow
Move to previous sheet
Alt+ Up Arrow
Display list of sheets
Alt+ Shift+ k
Open hyperlink
Alt+ Enter
Open Explore
Ctrl+ Alt+ Shift+ i
Go to side panel
Ctrl+ Alt+ .
Ctrl+ Alt+ ,
Ctrl+ Alt+ ,
Move focus out of spreadsheet
Ctrl+ Alt+ Shift+ m
Move to quicksum
(when a range of cells is selected)
(when a range of cells is selected)
Alt+ Shift+ q
Move focus to popup
(for links, bookmarks, and images)
(for links, bookmarks, and images)
holding Ctrl+ Alt, press ethen p
Open drop-down menu on filtered cell
Ctrl+ Alt+ r
Open revision history
Ctrl+ Alt+ Shift+ h
Close drawing editor
Shift+ Esc
Edit 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 ethen c
Move to next comment
holding Ctrl+ Alt, press nthen c
Move to previous comment
holding Ctrl+ Alt, press pthen c
Use keyboard shortcuts on selected comments
Reply to current comment
R
Move to next comment
J
Move to previous comment
K
Resolve current comment
E
Exit current comment
U
Open a menu
File menu
in Google Chrome:
Alt+ f
other browsers: Alt+ Shift+ f
other browsers: Alt+ Shift+ f
Edit menu
in Google Chrome:
Alt+ e
other browsers: Alt+ Shift+ e
other browsers: Alt+ Shift+ e
View menu
in Google Chrome:
Alt+ v
other browsers: Alt+ Shift+ v
other browsers: Alt+ Shift+ v
Insert menu
in Google Chrome:
Alt+ i
other browsers: Alt+ Shift+ i
other browsers: Alt+ Shift+ i
Format menu
in Google Chrome:
Alt+ o
other browsers: Alt+ Shift+ o
other browsers: Alt+ Shift+ o
Data menu
in Google Chrome:
Alt+ d
other browsers: Alt+ Shift+ d
other browsers: Alt+ Shift+ d
Tools menu
in Google Chrome:
Alt+ t
other browsers: Alt+ Shift+ t
other browsers: Alt+ Shift+ t
Open insert menu
Ctrl+ Alt+ =
(with cells selected)
(with cells selected)
Open delete menu
Ctrl+ Alt+ -(with cells selected)
Form menu
(present when the spreadsheet is connected to a form)
(present when the spreadsheet is connected to a form)
in Google Chrome:
Alt+ m
other browsers: Alt+ Shift+ m
other browsers: Alt+ Shift+ m
Add-ons menu
in Google Chrome:
Alt+ n
other browsers: Alt+ Shift+ n
other browsers: Alt+ Shift+ n
Help menu
in Google Chrome:
Alt+ h
other browsers: Alt+ Shift+ h
other browsers: Alt+ Shift+ h
Accessibility menu
(present when screen reader support is enabled)
(present when screen reader support is enabled)
in Google Chrome:
Alt+ a
other browsers: Alt+ Shift+ a
other browsers: Alt+ Shift+ a
Sheet menu
(copy, delete, and other sheet actions)
(copy, delete, and other sheet actions)
Alt+ Shift+ s
Context menu
Ctrl+ Shift+ \
Shift+ F10
Table column menu
Ctrl+ Alt+ \
Add or change rows and columns
Insert rows above
Ctrl+ Alt+ =
(with rows selected)
in Google Chrome:
Alt+ i, then r, then r
other browsers:
Alt+ Shift+ i, then r, then r
Insert rows below
in Google Chrome:
Alt+ i, then r, then b
other browsers: Alt+ Shift+ i, then r, then b
other browsers: Alt+ Shift+ i, then r, then b
Insert columns to the left
Ctrl+ Alt+ =
(with columns selected)
in Google Chrome:
Alt+ i, then c, then c
other browsers:
Alt+ Shift+ i, then c, then c
Insert columns to the right
in Google Chrome:
Alt+ i, then c
, then o
other browsers: Alt+ Shift+ i, then c, then o
other browsers: Alt+ Shift+ i, then c, then o
Delete rows
Ctrl+ Alt+ -(with rows selected)
in Google Chrome:
Alt+ e, then d, then d
other browsers:
Alt+ Shift+ e, then d, then d
Delete columns
Ctrl+ Alt+ -(with columns selected)
in Google Chrome:
Alt+ e, then d
, then e
other browsers:
Alt+ Shift+ e, then d
, then e
Hide row
Ctrl+ Alt+ 9
Unhide row
Ctrl+ Shift+ 9
Hide column
Ctrl+ Alt+ 0
Unhide column
Ctrl+ Shift+ 0
Group rows or columns
Alt+ Shift+ Right Arrow
Ungroup rows or columns
Alt+ Shift+ Left Arrow
Expand grouped rows or columns
Alt+ Shift+ Down Arrow
Collapse grouped rows or columns
Alt+ Shift+ Up Arrow
Use 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)
(when entering a formula)
Shift+ F1
Full/compact formula help
(when entering a formula)
(when entering a formula)
F1
Absolute/relative references
(when entering a formula)
(when entering a formula)
F4
Toggle formula result previews
(when entering a formula)
(when entering a formula)
F9
Resize formula bar
(move up or down)
(move up or down)
Ctrl+ Up / Ctrl+ Down
Toggle formula range selection (when entering a formula)
F2
Ctrl+ e
Help for screen readers
Ctrl+ Alt+ z
Enable braille support
Ctrl+ Alt+ h
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
⌘+ Shift+ Space
Undo
⌘+ z
Redo
⌘+ y
⌘+ Shift+ z
Fn+ F4
⌘+ 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)
(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
⌘+ /
Insert new sheet
Shift+ Fn+ F11
Compact controls
Ctrl+ Shift+ f
Input tools on/off
(available in spreadsheets in non-Latin languages)
(available in spreadsheets in non-Latin languages)
⌘+ Shift+ k
Select input tools
⌘+ Option+ Shift+ k
Tool finder (formerly Search the menus)
Option+ /
Select current region around selected cell
⌘+ Shift+ *
Ctrl+ Shift+ *
Ctrl+ Shift+ *
Displays or hides the menus
⌘+ Option+ R
Ctrl+ Shift+ F
Ctrl+ Shift+ F
Convert range to table
⌘ + Alt + T
Format cells
Bold
⌘+ b
⌘+ 2
Ctrl+ 2
Underline
⌘+ u
⌘+ 4
Ctrl+ 4
Italic
⌘+ i
⌘+ 3
Ctrl+ 3
⌘+ 3
Ctrl+ 3
Strikethrough
⌘+ Shift+ x
⌘+ 5
Ctrl+ 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
⌘+ Shift+ 7
Ctrl+ Shift+ 7
Insert link
⌘+ k
Insert time
⌘+ Shift+ ;
Insert date
⌘+ ;
Insert date and time
⌘+ Option+ Shift+ ;
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
⌘+ \
Navigate spreadsheet
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
Option+ Down Arrow
MacBook:
Option+ Right Arrow
Move to previous sheet
Option+ Up Arrow
MacBook:
Option+ Left Arrow
Display list of sheets
Option+ Shift+ k
Open hyperlink
Option+ Enter
Open Explore
⌘+ Option+ Shift+ i
Go to side panel
⌘+ Option+ .
⌘+ Option+ ,
⌘+ Option+ ,
Move focus out of spreadsheet
Ctrl+ ⌘+ Shift+ m
Move to quicksum
(when a range of cells is selected)
(when a range of cells is selected)
Option+ Shift+ q
Move focus to popup
(for links, bookmarks, and images)
(for links, bookmarks, and images)
holding Ctrl+ ⌘, press ethen p
Open drop-down menu on filtered cell
Ctrl+ ⌘+ r
Open revision history
⌘+ Option+ Shift+ h
Close drawing editor
⌘+ Esc
Shift+ Esc
Shift+ Esc
Show "Go to range" dialog
Ctrl+ G
Find and replace with Find tab selected
Ctrl+ F
Edit 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 ethen c
Move to next comment
holding Ctrl+ ⌘, press nthen c
Move to previous comment
holding Ctrl+ ⌘, press pthen c
Use keyboard shortcuts on selected comments
Reply to current comment
R
Move to next comment
J
Move to previous comment
K
Resolve current comment
E
Exit current comment
U
Open a menu
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
Open insert menu
⌘+ Option+ =(with cells selected)
Open delete menu
⌘+ Option+ -(with cells selected)
Form menu
(present when the spreadsheet is connected to a form)
(present when the spreadsheet is connected to a form)
Ctrl+ Option+ m
Add-ons menu
Ctrl+ Option+ n
Help menu
Ctrl+ Option+ h
Accessibility menu
(present when screen reader support is enabled)
(present when screen reader support is enabled)
Ctrl+ Option+ a
Sheet menu
(copy, delete, and other sheet actions)
(copy, delete, and other sheet actions)
Option+ Shift + s
Context menu
⌘+ Shift+ \
Shift+ F10
Table column menu
⌘+ Option+ \
Add or change rows and columns
Insert rows above
⌘+ Option+ =(with rows selected)
Ctrl+ Option+ i,press rthen r
Insert rows below
Ctrl+ Option+ i, press rthen b
Insert columns to the left
⌘+ Option+ =(with columns selected)
Ctrl+ Option+ i, press cthen c
Insert columns to the right
Ctrl+ Option+ i, press cthen o
Delete rows
⌘+ Option+ -(with rows selected)
Ctrl+ Option+ e, then d, then d
Ctrl+ Option+ e, then d, then d
Delete columns
⌘+ Option+ -(with columns selected)
Ctrl+ Option+ e, then d, then e
Ctrl+ Option+ e, then d, then e
Hide row
⌘+ Option+ 9
Unhide row
⌘+ Shift+ 9
Hide column
⌘+ Option+ 0
Unhide column
⌘+ Shift+ 0
Group rows or columns
Option+ Shift+ Right Arrow
Ungroup rows or columns
Option+ Shift+ Left Arrow
Expand grouped rows or columns
Option+ Shift+ Down Arrow
Collapse grouped rows or columns
Option+ Shift+ Up Arrow
Use formulas
Show all formulas
Ctrl+ ~
Insert array formula
⌘+ Shift+ Enter
Collapse an expanded array formula
⌘+ e
Show/hide formula help
(when entering a formula)
(when entering a formula)
Shift+ Fn+ F1
Full/compact formula help
(when entering a formula)
(when entering a formula)
Fn+ F1
Absolute/relative references
(when entering a formula)
(when entering a formula)
Fn+ F4
Toggle formula result previews
(when entering a formula)
(when entering a formula)
Fn+ F9
Resize formula bar
(move up or down)
(move up or down)
Ctrl+ Option+ Upand Ctrl+ Option+ Down
Toggle formula range selection (when entering a formula)
F2
Ctrl+ e
Help for screen readers
⌘+ Option+ z
Enable braille support
⌘+ Option+ h
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
Undo
Ctrl+ z
Redo
Ctrl+ y
Ctrl+ Shift+ z
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)
(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)
(available in spreadsheets in non-Latin languages)
Ctrl+ Shift+ k
Select input tools
Ctrl+ Alt+ Shift+ k
Tool finder (formerly Search the menus)
Alt+ /
Convert range to table
Shift+ Alt+ T
Format cells
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
Ctrl+ Shift+ 7
Insert link
Ctrl+ k
Insert time
Ctrl+ Shift+ ;
Insert date
Ctrl+ ;
Insert date and time
Ctrl+ Alt+ Shift+ ;
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+ \
Navigate spreadsheet
Move to beginning of row
Search+ Left Arrow
Move to end of row
Search+ Right Arrow
Move to first cell in row with data
Ctrl+ Left Arrow
Move to top left of sheet
Ctrl+ Search+ Left Arrow
Move to last cell in row with data
Ctrl+ Right Arrow
Move to bottom right of sheet
Ctrl+ Search+ Right Arrow
Scroll to active cell
Ctrl+ Backspace
Move to beginning of sheet
Ctrl+ Search+ Left Arrow
Move to end of sheet
Ctrl+ Search+ Right Arrow
Move to next sheet
Ctrl+ Shift+ Search+ Down Arrow
Move to previous sheet
Ctrl+ Shift+ Search+ Up Arrow
Display list of sheets
Alt+ Shift+ k
Open hyperlink
Alt+ Enter
Open Explore
Ctrl+ Alt+ Shift+ i
Go to side panel
Alt+ Shift+ .
Alt+ Shift+ ,
Alt+ Shift+ ,
Move focus out of spreadsheet
Ctrl+ Alt+ Shift+ m
Move to quicksum
(when a range of cells is selected)
(when a range of cells is selected)
Alt+ Shift+ q
Move focus to popup
(for links, bookmarks, and images)
(for links, bookmarks, and images)
holding Ctrl+ Alt, press ethen p
Open drop-down menu on filtered cell
Ctrl+ Alt+ r
Open revision history
Ctrl+ Alt+ Shift+ h
Close drawing editor
Ctrl+ Esc
Shift+ Esc
Shift+ Esc
Edit 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 ethen c
Move to next comment
holding Ctrl+ Alt, press nthen c
Move to previous comment
holding Ctrl+ Alt, press pthen c
Use keyboard shortcuts on selected comments
Reply to current comment
R
Move to next comment
J
Move to previous comment
K
Resolve current comment
E
Exit current comment
U
Open a menu
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
Open insert menu
Ctrl+ Alt+ =(with cells selected)
Open delete menu
Ctrl+ Alt+ -(with cells selected)
Form menu
(present when the spreadsheet is connected to a form)
(present when the spreadsheet is connected to a form)
Alt+ m
Add-ons menu
Alt+ n
Help menu
Alt+ h
Accessibility menu
(present when screen reader support is enabled)
(present when screen reader support is enabled)
Alt+ a
Sheet menu
(copy, delete, and other sheet actions)
(copy, delete, and other sheet actions)
Ctrl+ Shift+ s
Context menu
Ctrl+ Shift+ \
Shift+ F10
Table column menu
Ctrl+ Alt+ \
Add or change rows and columns
Insert rows above
Ctrl+ Alt+ =(with rows selected)
Alt+ i, then r, then r
Alt+ i, then r, then r
Insert rows below
Alt+ i, then r, then b
Insert columns to the left
Ctrl+ Alt+ =(with columns selected)
Alt+ i, then c, then c
Alt+ i, then c, then c
Insert columns to the right
Alt+ i, then c, then o
Delete rows
Ctrl+ Alt+ -(with rows selected)
Alt+ e, then d, then d
Alt+ e, then d, then d
Delete columns
Ctrl+ Alt+ -(with columns selected)
Alt+ e, then d, then e
Alt+ e, then d, then e
Hide rows
Ctrl+ Alt+ 9
Unhide rows
Ctrl+ Shift+ 9
Hide columns
Ctrl+ Alt+ 0
Unhide columns
Ctrl+ Shift+ 0
Group rows or columns
Alt+ Shift+ Right Arrow
Ungroup rows or columns
Alt+ Shift+ Left Arrow
Expand grouped rows or columns
Alt+ Shift+ Down Arrow
Collapse grouped rows or columns
Alt+ Shift+ Up Arrow
Use 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)
(when entering a formula)
Shift+ Search+ 1
Full/compact formula help (when entering a formula)
Search+ 1
Absolute/relative references (when entering a formula)
Search+ 4
Toggle formula result previews (when entering a formula)
Search+ 9
Resize formula bar (move up or down)
Ctrl+ Shift+ Up Arrowand
Ctrl+ Shift+ Down Arrow
Toggle formula range selection (when entering a formula)
F2
Ctrl+ e
Help for screen readers
Ctrl+ Alt+ z
Enable braille support
Ctrl+ Alt+ h
Read column
Ctrl+ Alt+ Shift+ c
Read row
Ctrl+ Alt+ Shift+ r
Use other spreadsheet shortcuts
You can use shortcuts for spreadsheets made by other companies in Google Sheets.
- On your computer, open a spreadsheet at sheets.google.com .
- At the top, click Help
Keyboard shortcuts .
- At the bottom of the window, turn on Enable compatible spreadsheet shortcuts.
