Google Sheets cheat sheet

89 shortcuts in 16 lessons

Start learning for free

Reading a list won't make them stick. ShortcutFoo has you type each shortcut, then brings it back just before you'd forget it.

Essentials I

7 shortcuts
  • ⌘C
    Copy
  • ⌘X
    Cut
  • ⌘V
    Paste
  • ⌘⇧V
    Paste values only
  • ⌘Z
    Undo
  • ⌘Y
    Redo
  • ⌘F
    Find in sheet

Essentials II

6 shortcuts
  • ⌘⇧H
    Find and replace
  • ⌘A
    Select all
  • ^SPACE
    Select column
  • ⇧SPACE
    Select row
  • ⌘B
    Bold
  • ⌘/
    Show keyboard shortcuts

Formatting I

7 shortcuts
  • ⌘I
    Italic
  • ⌘U
    Underline
  • ⌘⇧X
    Strikethrough
  • ⌘⇧E
    Center align
  • ⌘⇧L
    Left align
  • ⌘⇧R
    Right align
  • ⌘\
    Clear formatting

Formatting II

7 shortcuts
  • ⌘K
    Insert link
  • ^⇧!
    Format as decimal
  • ^⇧@
    Format as time
  • ^⇧#
    Format as date
  • ^⇧$
    Format as currency
  • ^⇧%
    Format as percentage
  • ^⇧^
    Format as exponent

Navigation I

6 shortcuts
  • HOME
    Move to beginning of row
  • END
    Move to end of row
  • ⌘HOME
    Move to beginning of sheet
  • ⌘END
    Move to end of sheet
  • ⌘BACKSPACE
    Scroll to active cell
  • ⌥DOWN
    Move to next sheet

Navigation II

6 shortcuts
  • ⌥UP
    Move to previous sheet
  • ⌥⇧K
    Display list of sheets
  • ⌥↵
    Open hyperlink
  • ^G
    Go to range
  • ⌥/
    Open tool finder
  • ⌥⇧Q
    Move to quicksum

Data entry I

4 shortcuts
  • ⌘D
    Fill down
  • ⌘R
    Fill right
  • ⌘↵
    Fill range
  • ⌘;
    Insert date

Data entry II

4 shortcuts
  • ⌘⇧:
    Insert time
  • ⌘⌥⇧:
    Insert date and time
  • ⇧F11
    Insert new sheet
  • ⌘⌥T
    Convert range to table

Rows and columns I

6 shortcuts
  • ⌘⌥=
    Open insert menu
  • ⌘⌥-
    Open delete menu
  • ^⌥IRB
    Insert rows below
  • ^⌥ICO
    Insert columns to the right
  • ⌘⌥9
    Hide row
  • ⌘⇧(
    Unhide row

Rows and columns II

6 shortcuts
  • ⌘⌥0
    Hide column
  • ⌘⇧)
    Unhide column
  • ⌥⇧RIGHT
    Group rows or columns
  • ⌥⇧LEFT
    Ungroup rows or columns
  • ⌥⇧DOWN
    Expand grouped rows or columns
  • ⌥⇧UP
    Collapse grouped rows or columns

Formulas I

5 shortcuts
  • ^⇧`
    Show all formulas
  • ⌘⇧↵
    Insert array formula
  • ⌘E
    Collapse an expanded array formula
  • ⇧F1
    Show or hide formula help
  • F1
    Toggle full or compact formula help

Formulas II

5 shortcuts
  • F4
    Toggle absolute and relative references
  • F9
    Toggle formula result previews
  • F2
    Toggle formula range selection
  • ^⌥DOWN
    Make the formula bar taller
  • ^⌥UP
    Make the formula bar shorter

Menus and panels I

5 shortcuts
  • ^⌥F
    Open the File menu
  • ^⌥E
    Open the Edit menu
  • ^⌥V
    Open the View menu
  • ^⌥I
    Open the Insert menu
  • ^⌥O
    Open the Format menu

Menus and panels II

5 shortcuts
  • ^⌥D
    Open the Data menu
  • ^⌥T
    Open the Tools menu
  • ⌘⇧|
    Open the context menu
  • ⌘⌥⇧I
    Open Explore
  • ⌘⌥⇧H
    Open version history

Comments and notes I

5 shortcuts
  • ⇧F2
    Insert or edit a note
  • ⌘⌥M
    Insert or edit a comment
  • ⌘⌥⇧A
    Open comment discussion thread
  • ⌘^E⌘^C
    Enter the current comment
  • ⌘^P⌘^C
    Move to the previous comment

Comments and notes II

5 shortcuts
  • R
    Reply to the selected comment
  • J
    Jump to the next selected comment
  • K
    Jump to the previous selected comment
  • E
    Resolve the selected comment
  • U
    Exit the selected comment
Achievement unlocked