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