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
F4
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
Shift + F11
Move to sheet at index # Ctrl + [1-9]
Open Ctrl + O

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
Ctrl + Shift + 7
Insert link Ctrl + k
Insert time Ctrl + Shift + ;
Insert date Ctrl + ;
Insert date and time Ctrl + Alt + Shift + ;
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)
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

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 Alt + Down arrow
Ctrl + Shift + Page Down
Move to previous sheet Alt + Up arrow
Ctrl + Shift + Page Up
Display list of sheets Alt + Shift + k
Open hyperlink Alt + Enter
Open Explore Alt + Shift + x
Open menu on filtered cell Ctrl + Alt + Shift + r
Ctrl + Alt + r
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

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 Alt + i
Format menu Alt + o
Sheet menu
(copy, delete, and other sheet actions)
Alt + Shift + s
Context menu

Ctrl + Shift + \
Shift + F10
Alt + Space

Right-click

Use formulas

Action Shortcut

Insert array formula

Ctrl + Shift + Enter

Show expanded function help (when entering a formula)

F1

Toggle formula range selection (when entering a formula)

F2
Ctrl + e

Absolute/relative range references (when entering a formula)

F4

 

true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu
12007944938464254879
true