Google Workspace

Google Sheets Shortcuts

Learn useful keyboard shortcuts for Google Sheets

Bold

Formatting

Make selected cells bold

Windows:
Ctrl+
B
Click to view details →

Italic

Formatting

Make selected cells italic

Windows:
Ctrl+
I
Click to view details →

Underline

Formatting

Underline selected cells

Windows:
Ctrl+
U
Click to view details →

Copy

Edit

Copy selected cells

Windows:
Ctrl+
C
Click to view details →

Paste

Edit

Paste copied cells

Windows:
Ctrl+
V
Click to view details →

Cut

Edit

Cut selected cells

Windows:
Ctrl+
X
Click to view details →

Undo

Edit

Undo last action

Windows:
Ctrl+
Z
Click to view details →

Redo

Edit

Redo undone action

Windows:
Ctrl+
Y
Click to view details →

Find

Edit

Find text in spreadsheet

Windows:
Ctrl+
F
Click to view details →

Replace

Edit

Find and replace text

Windows:
Ctrl+
H
Click to view details →

Select All

Edit

Select entire spreadsheet

Windows:
Ctrl+
A
Click to view details →

Save

File

Save spreadsheet

Windows:
Ctrl+
S
Click to view details →

New Spreadsheet

File

Create new spreadsheet

Windows:
Ctrl+
N
Click to view details →

Open

File

Open existing spreadsheet

Windows:
Ctrl+
O
Click to view details →

Print

File

Print spreadsheet

Windows:
Ctrl+
P
Click to view details →

Insert Row

Insert

Insert row above selected row

Windows:
Ctrl+
Alt+
I+
R
Click to view details →

Insert Column

Insert

Insert column to left of selected column

Windows:
Ctrl+
Alt+
I+
C
Click to view details →

Delete Row

Edit

Delete selected row

Windows:
Ctrl+
Alt+
E+
R
Click to view details →

Delete Column

Edit

Delete selected column

Windows:
Ctrl+
Alt+
E+
C
Click to view details →

Insert Function

Insert

Insert function

Windows:
Shift+
F3
Click to view details →

AutoSum

Data

Auto calculate sum of selected range

Windows:
Alt+
=
Click to view details →

Fill Down

Edit

Copy selected cell content down

Windows:
Ctrl+
D
Click to view details →

Fill Right

Edit

Copy selected cell content right

Windows:
Ctrl+
R
Click to view details →

Format Cells

Formatting

Open Format Cells dialog

Windows:
Ctrl+
1
Click to view details →

Align Left

Formatting

Left align cell content

Windows:
Ctrl+
Shift+
L
Click to view details →

Center Align

Formatting

Center align cell content

Windows:
Ctrl+
Shift+
E
Click to view details →

Align Right

Formatting

Right align cell content

Windows:
Ctrl+
Shift+
R
Click to view details →

Sort Ascending

Data

Sort selected range in ascending order

Windows:
Alt+
A+
S+
A
Click to view details →

Sort Descending

Data

Sort selected range in descending order

Windows:
Alt+
A+
S+
D
Click to view details →

Filter

Data

Create or remove filter

Windows:
Ctrl+
Shift+
F
Click to view details →

Insert Chart

Insert

Insert chart

Windows:
Alt+
I+
C
Click to view details →

Freeze Rows

View

Freeze selected rows

Windows:
Alt+
V+
F+
R
Click to view details →

Freeze Columns

View

Freeze selected columns

Windows:
Alt+
V+
F+
C
Click to view details →