Google Sheets logo

Google Sheets

Web-based spreadsheet application with real-time collaboration, formulas, and data visualization

168 shortcuts

Visit website
Platform

Common Actions

ActionShortcut
Copy+C
Cut+X
Paste+V
Paste values only++V
Undo+Z
Redo++Z
Find+F
Find and replace++H
Fill down+D
Fill right+R
Save+S
Open+O
Print+P
Show keyboard shortcuts+/
Insert new sheet+F11
Search the menus+/
Copy+C
Cut+X
Paste+V
Paste values only++V
Undo+Z
Redo+Y
Find+F
Find and replace+H
Fill down+D
Fill right+R
Save+S
Open+O
Print+P
Show keyboard shortcuts+/
Insert new sheet+F11
Search the menus+/

Cell Formatting

ActionShortcut
Bold+B
Italic+I
Underline+U
Strikethrough++5
Center align++E
Left align++L
Right align++R
Apply top border++1
Apply right border++2
Apply bottom border++3
Apply left border++4
Remove borders++6
Apply outer border++7
Clear formatting+\
Bold+B
Italic+I
Underline+U
Strikethrough++5
Center align++E
Left align++L
Right align++R
Apply top border++1
Apply right border++2
Apply bottom border++3
Apply left border++4
Remove borders++6
Apply outer border++7
Clear formatting+\

Number Formatting

ActionShortcut
Format as decimal++1
Format as time++2
Format as date++3
Format as currency++4
Format as percentage++5
Format as exponent++6
Format as decimal++1
Format as time++2
Format as date++3
Format as currency++4
Format as percentage++5
Format as exponent++6

Selection

ActionShortcut
Select column+Space
Select row+Space
Select all+A
Extend selection up+
Extend selection down+
Extend selection left+
Extend selection right+
Extend selection to start of row+Home
Extend selection to end of row+End
Extend selection to data region edge+Arrow
Select column+Space
Select row+Space
Select all+A
Extend selection up+
Extend selection down+
Extend selection left+
Extend selection right+
Extend selection to start of row+Home
Extend selection to end of row+End
Extend selection to data region edge+Arrow

Navigation

ActionShortcut
Move to edge of data regionArrow
Move to beginning of rowHome
Move to beginning of sheet+Home
Move to end of sheet+End
Go to next sheet+PageDown
Go to previous sheet+PageUp
Scroll to active cell+Backspace
Move to edge of data regionArrow
Move to beginning of rowHome
Move to beginning of sheet+Home
Move to end of sheet+End
Go to next sheetPageDown
Go to previous sheetPageUp
Scroll to active cell+Backspace

Rows & Columns

ActionShortcut
Insert rows above++=
Insert rows below++=then++B
Insert columns left++=
Delete rows++-
Delete columns++-
Hide row++9
Unhide row++9
Hide column++0
Unhide column++0
Group rows/columns++
Ungroup rows/columns++
Insert rows above++=
Delete rows++-
Delete columns++-
Hide row++9
Unhide row++9
Hide column++0
Unhide column++0
Group rows/columns++
Ungroup rows/columns++

Formulas

ActionShortcut
Show all formulas+`
Insert array formula++
Collapse array formula+E
Show formula help+F1
Toggle absolute/relative referenceF4
Insert/edit note+F2
Insert/edit comment++M
Show all formulas+`
Insert array formula++Enter
Collapse array formula+E
Show formula help+F1
Toggle absolute/relative referenceF4
Insert/edit note+F2
Insert/edit comment++M

Editing

ActionShortcut
Edit cellF2
Insert link+K
Insert current date+;
Insert current time++;
Insert current date and time+++;
Fill range+
Clear cellDelete
Edit cellF2
Insert link+K
Insert current date+;
Insert current time++;
Insert current date and time+++;
Fill range+Enter
Clear cellDelete

Menu Access

ActionShortcut
File menu++F
Edit menu++E
View menu++V
Insert menu++I
Format menu++O
Data menu++D
Tools menu++T
File menu+F
Edit menu+E
View menu+V
Insert menu+I
Format menu+O
Data menu+D
Tools menu+T