Google Sheets

Google Sheets

Productivity

∙

136 Shortcuts

Visit Website

Common Actions

Select column

⌃space

Select row

⇧space

Select all

⌘a

Select all

⌘⇧space

Undo

⌘z

Redo

⌘y

Redo

fnf4

Find

⌘f

Find and replace

⌘⇧h

Fill range

⌘Return

Fill down

⌘d

Fill right

⌘r

Save

⌘s

Open

⌘o

Print

⌘p

Copy

⌘c

Cut

⌘x

Paste

⌘v

Paste values only

⌘⇧v

Show common keyboard shortcuts

⌘/

Insert new sheet

⇧fnf11

Compact controls

⌃⇧f

Input tools on/off

⌘⇧k

Select input tools

⌘⌥⇧k

Tool finder (formerly Search the menus)

⌥/

Select current region around selected cell

⌘⇧*

Displays or hides the menus

⌘⌥r

Convert range to table

⌘⌥t

Format Cells

Bold

⌘b

Bold

⌘2

Underline

⌘u

Underline

⌘4

Italic

⌘i

Italic

⌘3

Strikethrough

⌘⇧x

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

Apply outer border

⌘⇧7

Insert link

⌘k

Insert time

⌘⇧;

Insert date

⌘;

Insert date and time

⌘⌥⇧;

Format as decimal

⌃⇧1

Format as time

⌃⇧2

Format as date

⌃⇧3

Format as currency

⌃⇧4

Format as percentage

⌃⇧5

Format as exponent

⌃⇧6

Clear formatting

⌘\

Navigate Spreadsheet

Move to beginning of row

fn←

Move to beginning of sheet

⌘fn←

Move to end of row

fn→

Move to end of sheet

⌘fn→

Scroll to active cell

⌘delete

Move to next sheet

⌥↓

Move to next sheet

⌥→

Move to previous sheet

⌥↑

Move to previous sheet

⌥←

Display list of sheets

⌥⇧k

Open hyperlink

⌥Return

Open Explore

⌘⌥⇧i

Go to side panel

⌘⌥.

Go to side panel

⌘⌥,

Move focus out of spreadsheet

⌃⌘⇧m

Move to quicksum

⌥⇧q

Move focus to popup

⌃⌘
then
e
then
p

Open drop-down menu on filtered cell

⌃⌘r

Open revision history

⌘⌥⇧h

Close drawing editor

⌘esc

Close drawing editor

⇧esc

Show 'Go to range' dialog

⌃g

Find and replace with Find tab selected

⌃f

Edit Notes and Comments

Insert/edit note

⇧f2

Insert/edit comment

⌘⌥m

Open comment discussion thread

⌘⌥⇧a

Enter current comment

⌃⌘
then
e
then
c

Move to next comment

⌃⌘
then
n
then
c

Move to previous comment

⌃⌘
then
p
then
c

Use keyboard shortcuts on selected comments

Reply to current comment

r

Move to next comment

j

Move to previous comment

k

Resolve current comment

e

Exit current comment

u

Open a Menu

File menu

⌃⌥f

Edit menu

⌃⌥e

View menu

⌃⌥v

Insert menu

⌃⌥i

Format menu

⌃⌥o

Data menu

⌃⌥d

Tools menu

⌃⌥t

Open insert menu (with cells selected)

⌘⌥=

Open delete menu (with cells selected)

⌘⌥-

Form menu

⌃⌥m

Add-ons menu

⌃⌥n

Help menu

⌃⌥h

Accessibility menu

⌃⌥a

Sheet menu

⌥⇧s

Context menu

⌘⇧\

Context menu

⇧f10

Table column menu

⌘⌥\

Add or Change Rows and Columns

Insert rows above (with rows selected)

⌘⌥=

Insert rows above

⌃⌥i
then
r
then
r

Insert rows below

⌃⌥i
then
r
then
b

Insert columns to the left (with columns selected)

⌘⌥=

Insert columns to the left

⌃⌥i
then
c
then
c

Insert columns to the right

⌃⌥i
then
c
then
o

Delete rows (with rows selected)

⌘⌥-

Delete rows

⌃⌥e
then
d
then
d

Delete columns (with columns selected)

⌘⌥-

Delete columns

⌃⌥e
then
d
then
e

Hide row

⌘⌥9

Unhide row

⌘⇧9

Hide column

⌘⌥0

Unhide column

⌘⇧0

Group rows or columns

⌥⇧→

Ungroup rows or columns

⌥⇧←

Expand grouped rows or columns

⌥⇧↓

Collapse grouped rows or columns

⌥⇧↑

Use Formulas

Show all formulas

⌃~

Insert array formula

⌘⇧Return

Collapse an expanded array formula

⌘e

Show/hide formula help

⇧fnf1

Full/compact formula help

fnf1

Absolute/relative references

fnf4

Toggle formula result previews

fnf9

Resize formula bar

⌃⌥↑

Resize formula bar

⌃⌥↓

Toggle formula range selection

f2
then
⌃e

Disclaimer: We are not affiliated with Google Sheets. All product names, logos, and trademarks belong to their respective owners.

Last updated: 08-02-2025