SheetSkill
Shortcut lessonsLesson 9 of 12
Practice sheetClick a cell once, then keep your hands on the keyboard.
A1
Click a cell, then type. Right-click for rows, columns, sort and filter.
A
B
C
D
E
F
G
H
I
J
K
L
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
Region
Rep
Product
Units
Sales
0.1
Extras
North
Asha
Pens
20
70
12
South
Ben
Folders
57
256.5
30
East
Chen
Ink
94
517
7
West
Dee
Paper
41
143.5
18
North
Eli
Pens
78
351
25
South
Fay
Folders
25
137.5
East
Gus
Ink
62
217
Today
West
Hana
Paper
99
445.5
North
Ivo
Pens
46
253
South
Jo
Folders
83
290.5
East
Kai
Ink
30
135
West
Lia
Paper
67
368.5
702

Conditional formatting

A number, or a cell like =$H$1

AaBbCc 123

Rules on this sheet (0)

No rules yet. When several rules affect the same cell, the one higher in this list wins.

Find and Replace

Go To

Format Cells

SampleRegion

No specific number format.

Insert Hyperlink

A cell reference like Sheet2!A1 links to a place in this workbook. Ctrl+click a link cell to open it.

New note · A1

Notes show as a red corner. Ctrl+Enter saves.

Insert Function

SUM(number1, [number2], …)
Adds numbers