Google Sheets Keyboard Shortcuts

Cheat sheet guide

Google Sheets shortcuts worth learning first

This page collects 120 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

35 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

Select all cells

CtrlACtrlShiftSpace

Ctrl+A · Ctrl+Shift+Space · Cmd+A · Shift+Cmd+Space

Show keyboard shortcuts

Ctrl/

Ctrl+/ · Cmd+/

Toggle compact controls

CtrlShiftF

Ctrl+Shift+F

Open tool finder

Alt/

Alt+/ · Opt+/

Move to end of row

End

End · Fn+→

Show sheet list

AltShiftK

Alt+Shift+K · Opt+Shift+K

Cell link: open hyperlink

AltEnter

Alt+Enter · Opt+Enter

Go to side panel

CtrlAlt.CtrlAlt,

Ctrl+Alt+. · Ctrl+Alt+, · Opt+Cmd+. · Opt+Cmd+,

Move focus out of spreadsheet

CtrlAltShiftM

Ctrl+Alt+Shift+M · Ctrl+Shift+Cmd+M

Selected range: focus quicksum

AltShiftQ

Alt+Shift+Q · Opt+Shift+Q

Enable braille support

CtrlAltH

Ctrl+Alt+H · Opt+Cmd+H

Editing

34 shortcuts

Edit active cell

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

Fill selected range

CtrlEnter

Ctrl+Enter · Cmd+Enter

Save spreadsheet

CtrlS

Ctrl+S · Cmd+S

Open spreadsheet

CtrlO

Ctrl+O · Cmd+O

Print spreadsheet

CtrlP

Ctrl+P · Cmd+P

Toggle input tools for non-Latin text

CtrlShiftK

Ctrl+Shift+K · Shift+Cmd+K

Choose input tools

CtrlAltShiftK

Ctrl+Alt+Shift+K · Opt+Shift+Cmd+K

Insert cell link

CtrlK

Ctrl+K · Cmd+K

Open version history

CtrlAltShiftH

Ctrl+Alt+Shift+H · Opt+Shift+Cmd+H

Close drawing editor

ShiftEsc

Shift+Esc · Cmd+Esc

Insert or edit cell note

ShiftF2

Shift+F2

Open comment thread

CtrlAltShiftA

Ctrl+Alt+Shift+A · Opt+Shift+Cmd+A

Enter current comment

CtrlAltECtrlAltC

Ctrl+Alt+E Ctrl+Alt+C · Ctrl+Cmd+E Ctrl+Cmd+C

Next comment

CtrlAltNCtrlAltC

Ctrl+Alt+N Ctrl+Alt+C · Ctrl+Cmd+N Ctrl+Cmd+C

Previous comment

CtrlAltPCtrlAltC

Ctrl+Alt+P Ctrl+Alt+C · Ctrl+Cmd+P Ctrl+Cmd+C

Selected comment: reply

R

Selected comment: next

J

Selected comment: previous

K

Selected comment: resolve

E

Selected comment: exit

U

Formatting

20 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+\

Apply top cell border

AltShift1

Alt+Shift+1 · Opt+Shift+1

Apply right cell border

AltShift2

Alt+Shift+2 · Opt+Shift+2

Apply bottom cell border

AltShift3

Alt+Shift+3 · Opt+Shift+3

Apply left cell border

AltShift4

Alt+Shift+4 · Opt+Shift+4

Remove cell borders

AltShift6

Alt+Shift+6 · Opt+Shift+6

Apply outer cell border

AltShift7CtrlShift7

Alt+Shift+7 · Ctrl+Shift+7 · Opt+Shift+7 · Shift+Cmd+7

Format as decimal

CtrlShift1

Ctrl+Shift+1

Format as time

CtrlShift2

Ctrl+Shift+2

Format as exponent

CtrlShift6

Ctrl+Shift+6

Rows & Columns

18 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

Insert new sheet

ShiftF11

Shift+F11 · Shift+Fn+F11

Rename sheet

Alt1

Alt+1

Convert range to table

CtrlAltT

Ctrl+Alt+T · Opt+Cmd+T

Unhide row

CtrlShift9

Ctrl+Shift+9 · Shift+Cmd+9

Unhide column

CtrlShift0

Ctrl+Shift+0 · Shift+Cmd+0

Ungroup rows or columns

AltShift←

Alt+Shift+← · Opt+Shift+←

Expand grouped rows or columns

AltShift↓

Alt+Shift+↓ · Opt+Shift+↓

Collapse grouped rows or columns

AltShift↑

Alt+Shift+↑ · Opt+Shift+↑

Formulas

13 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

Sum selected cells

Alt=

Alt+= · Cmd+Shift+T

Insert comment

CtrlAltM

Ctrl+Alt+M · Cmd+Opt+M

Insert array formula

CtrlShiftEnter

Ctrl+Shift+Enter · Shift+Cmd+Enter

Collapse expanded array formula

CtrlE

Ctrl+E · Cmd+E

Formula entry: toggle help

ShiftF1

Shift+F1 · Shift+Fn+F1

Formula entry: full or compact help

F1

F1 · Fn+F1

Formula entry: toggle result preview

F9

F9 · Fn+F9

Resize formula bar

Ctrl↑Ctrl↓

Ctrl+↑ · Ctrl+↓ · Ctrl+Opt+↑ · Ctrl+Opt+↓

Formula entry: toggle range selection

F2CtrlE

F2 · Ctrl+E

Documentation check for this addition

74 additional actions were checked against the official documentation on 2026-11-05. Existing actions were retained. These are documentary checks, not tests in installed applications. A dash means this batch does not provide a verified binding for that system. Context such as PDF viewer, text field or address bar is part of the action.

Google Sheets