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 region⌘Arrow
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 region⌃Arrow
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

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