Google Sheets Shortcut Keys
Common Actions & Nav
CTRL + Z
Undo last action
CTRL + Y
Redo last action
CTRL + K
Insert hyperlink
CTRL + F
Find in spreadsheet
CTRL + H
Find and replace
CTRL + /
Show keyboard shortcuts list
CTRL + P
Print spreadsheet
CTRL + S
Save (Auto-saved)
Rows & Columns Management
ALT + I, R (or Ctrl + Alt + =)
Insert row above
ALT + I, C (or Ctrl + Alt + =)
Insert column left
ALT + E, D (or Ctrl + Alt + -)
Delete selected row / column
CTRL + ALT + 9
Hide row
CTRL + SHIFT + 9
Unhide row
CTRL + ALT + 0
Hide column
CTRL + SHIFT + 0
Unhide column
ALT + SHIFT + RIGHT
Group rows or columns
Formatting & Data Types
CTRL + SHIFT + 1
Format as decimal number
CTRL + SHIFT + 4 ($)
Format as currency ($)
CTRL + SHIFT + 5 (%)
Format as percentage (%)
CTRL + SHIFT + 3 (#)
Format as date (YYYY-MM-DD)
CTRL + SHIFT + 2 (@)
Format as time (HH:MM:SS)
CTRL + B
Bold text
ALT + SHIFT + 5
Strikethrough text
CTRL + \
Clear all cell formatting
Formulas & Functions
F4
Toggle absolute reference ($)
CTRL + `
Toggle show all formulas
CTRL + SHIFT + ENTER
Insert ArrayFormula()
ALT + =
Insert AutoSum formula
CTRL + ;
Insert current date
CTRL + SHIFT + :
Insert current time
F2
Edit formula / cell
F1
Toggle formula helper popup
Data & Paste Options
CTRL + SHIFT + V
Paste values only
CTRL + ALT + V
Paste format only
ALT + D, F
Create filter / toggle filter
CTRL + ALT + R
Open filter menu dropdown on a filtered cell
ALT + I, H
Insert Chart
CTRL + D
Fill down from top cell
CTRL + R
Fill right from left cell
Text & Cell Alignment
ALT + ENTER
Line break inside cell
CTRL + SHIFT + L
Align text left
CTRL + SHIFT + E
Center align text
CTRL + SHIFT + R
Align text right
CTRL + I
Italics text
CTRL + U
Underline text
ALT + O, W, W
Wrap text in cell
Sheet Tabs & Views
ALT + DOWN ARROW
Move to next sheet tab
ALT + UP ARROW
Move to previous sheet tab
SHIFT + F11
Insert new sheet tab
ALT + SHIFT + K
Open list of sheets
CTRL + ALT + SHIFT + M
Move sheet tab right
CTRL + ALT + SHIFT + J
Move sheet tab left
Selection & Navigation
SHIFT + SPACE
Select entire row
CTRL + SPACE
Select entire column
CTRL + A
Select all cells in sheet
CTRL + ARROWS
Jump to edge of data region
CTRL + SHIFT + ARROWS
Select range to edge of data
CTRL + HOME
Jump to cell A1 (Top Left)
CTRL + END
Jump to bottom-right cell
CTRL + BACKSPACE
Scroll back to active cell
Comments & Collaboration
CTRL + ALT + M
Insert comment on cell
SHIFT + F2
Insert / Edit cell note
CTRL + ALT + SHIFT + H
Open version / revision history
CTRL + ALT + SHIFT + A
Open comment history stream
SHIFT + ESC
Close active comment popup
Was this article helpful?
Comments
0Share your thoughts, questions, or feedback about this guide.