› Google Sheets

Google Sheets Shortcuts

Google Sheets keyboard shortcuts for navigation, formatting, formulas and data entry.

Source: Official documentation · Dataset date 2026-06

46
Shortcuts
5
Categories
Press / to search. Press Esc to leave search.

Cheat sheet guide

Google Sheets shortcuts worth learning first

This page collects 46 searchable Google Sheets keyboard shortcuts across 5 categories. Start with the shortcuts for Navigation, Editing, Formatting, Rows & Columns, then print the cheat sheet once the important ones are worth keeping nearby.

  • Move to beginning of rowHome
  • Edit active cellF2
  • BoldCtrlB
  • Insert row aboveCtrlAltShift=
  • Show all formulasCtrl`
  • Move to beginning of sheetCtrlHome

Navigation

8 shortcuts
Move to beginning of row
Home
Home · Fn+Left
Move to beginning of sheet
CtrlHome
Ctrl+Home · Cmd++Home · Ctrl+Cmd++Left
Move to end of sheet
CtrlEnd
Ctrl+End · Cmd++End
Move to next sheet
CtrlPageDown
Ctrl+PageDown · Cmd++Shift++PgDn
Move to previous sheet
CtrlPageUp
Ctrl+PageUp · Cmd++Shift++PgUp
Jump to range
CtrlG
Ctrl+G · Cmd+G
Go to cell A1
CtrlHome
Ctrl+Home · Cmd++Fn+Left
Scroll to active cell
CtrlBackspace
Ctrl+Backspace · Cmd++Backspace

Editing

13 shortcuts
Edit active cell
F2
F2
Undo
CtrlZ
Ctrl+Z · Cmd+Z
Redo
CtrlY
Ctrl+Y · Cmd+Y
Cut
CtrlX
Ctrl+X · Cmd+X
Copy
CtrlC
Ctrl+C · Cmd+C
Paste
CtrlV
Ctrl+V · Cmd+V
Paste values only
CtrlShiftV
Ctrl+Shift+V · Cmd+Shift+V
Fill down
CtrlD
Ctrl+D · Cmd+D
Fill right
CtrlR
Ctrl+R · Cmd+R
Insert new line in cell
AltEnter
Alt+Enter · Ctrl+Opt+Enter
Delete cell contents
Delete
Delete · Backspace
Find and replace
CtrlH
Ctrl+H · Cmd+H
Find
CtrlF
Ctrl+F · Cmd+F

Formatting

11 shortcuts
Bold
CtrlB
Ctrl+B · Cmd+B
Italic
CtrlI
Ctrl+I · Cmd+I
Underline
CtrlU
Ctrl+U · Cmd+U
Strikethrough
AltShift5
Alt+Shift+5 · Opt+Shift+5
Format as currency
CtrlShift4
Ctrl+Shift+4 · Cmd+Shift+4
Format as percentage
CtrlShift5
Ctrl+Shift+5 · Cmd+Shift+5
Format as date
CtrlShift3
Ctrl+Shift+3 · Cmd+Shift+3
Align left
CtrlShiftL
Ctrl+Shift+L · Cmd+Shift+L
Align center
CtrlShiftE
Ctrl+Shift+E · Cmd+Shift+E
Align right
CtrlShiftR
Ctrl+Shift+R · Cmd+Shift+R
Clear formatting
Ctrl\
Ctrl+\ · Cmd+\

Rows & Columns

8 shortcuts
Insert row above
CtrlAltShift=
Ctrl+Alt+Shift+= · Cmd+Opt+Shift+=
Insert column left
CtrlAlt=
Ctrl+Alt+= · Cmd+Opt+=
Delete row
CtrlAlt-
Ctrl+Alt+- · Cmd+Opt+-
Select entire row
ShiftSpace
Shift+Space
Select entire column
CtrlSpace
Ctrl+Space
Hide row
CtrlAlt9
Ctrl+Alt+9 · Cmd+Opt+9
Hide column
CtrlAlt0
Ctrl+Alt+0 · Cmd+Opt+0
Group rows/columns
AltShiftRight
Alt+Shift+Right · Opt+Shift+Right

Formulas

6 shortcuts
Show all formulas
Ctrl`
Ctrl+`
Insert current date
Ctrl;
Ctrl+; · Cmd+;
Insert current time
CtrlShift;
Ctrl+Shift+; · Cmd+Shift+;
Toggle absolute/relative reference
F4
F4
Sum selected cells
Alt=
Alt+= · Cmd+Shift+T
Insert comment
CtrlAltM
Ctrl+Alt+M · Cmd+Opt+M

Frequently asked questions

What is the fastest way to find Google Sheets shortcuts on this page?

Use the search box or press /, then type an action such as move to beginning of row.

Can I print this Google Sheets shortcut cheat sheet?

Yes. Use the Print / PDF button or your browser print command to save a compact cheat sheet.

Which operating systems are included for Google Sheets?

This reference includes shortcuts for Windows · macOS · Linux. Availability depends on the action and app version.

Chrome23 shortcuts→Gmail40 shortcuts→Google Drive32 shortcuts→Google Slides44 shortcuts→Apple Numbers22 shortcuts→Asana28 shortcuts→

See also

UndoRedoCutCopyPasteWindows keyboard shortcutsmacOS keyboard shortcutsKeyboard shortcut database

Explore shortcuts by key

Key lookup

Compare shortcuts

Google Sheets / Excel

No shortcuts match your search.