Keyboard shortcuts for Google Sheets

Use keyboard shortcuts in Google Sheets to navigate, format, and use formulas.

Note: Some shortcuts might not work for all languages or keyboards.

If you plug an external keyboard into your Android device, you can use the shortcuts below. This works with most kinds of external keyboards. 

Common actions

Action Shortcut
Select column Ctrl + Space
Select row Shift + Space
Select all Ctrl + a
Ctrl + Shift + Space
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
Print Ctrl + p
Copy Ctrl + c
Cut Ctrl + x
Paste Ctrl + v
Paste values only Ctrl + Shift + v
Paste format only Ctrl + Alt + v
Show common keyboard shortcuts Ctrl + /
Insert new sheet Ctrl + t
Move to sheet at index # Ctrl + [1-9]

Format cells

Action Shortcut
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 automatic Ctrl + 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 + \
Insert rows

Ctrl + Alt + =
Ctrl + Alt + Shift + = 

(with rows selected)

Insert columns

Ctrl + Alt + =
Ctrl + Alt + Shift + = 

(with columns selected)

Delete rows Ctrl + Alt + - (with rows selected)
Delete columns Ctrl + Alt + - (with columns selected)
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

Navigate spreadsheet

Action Shortcut
Move to section boundary Ctrl + Arrow keys
Select from current position to section boundary Ctrl + Shift + Arrow keys
Scroll to active cell Ctrl + Backspace
Move to next sheet Ctrl + Tab
Move to previous sheet Ctrl + Shift + Tab
Display list of sheets Alt + Shift + k
Open hyperlink Alt + Enter
Open Explore Alt + Shift + x

Edit notes and comments

Action Shortcut
Insert/edit note Shift + F2
Insert/edit comment Ctrl + Alt + m
Open comment discussion thread Ctrl + Alt + Shift + a

Open a menu

Action Shortcut
Insert menu in Google Chrome: Alt + i
other browsers: Alt + Shift + i
Format menu in Google Chrome: Alt + o
other browsers: Alt + Shift + o
Sheet menu
(copy, delete, and other sheet actions)
Alt + Shift + s
Context menu Ctrl + Shift + \

 

Was this helpful?
How can we improve it?