SheetSkill
Shortcut lessonsLesson 7 of 12
Practice sheetClick a cell once, then keep your hands on the keyboard.
Undo
Clipboard
Font
Alignment
Number
Styles
Cells
Editing
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
Growth
Order date
North
Asha
Pens
20
70
-0.08
45658
South
Ben
Folders
57
256.5
-0.01
45667
East
Chen
Ink
94
517
0.06
45676
West
Dee
Paper
41
143.5
0.13
45685
North
Eli
Pens
78
351
0.2
45694
South
Fay
Folders
25
137.5
-0.03
45703
East
Gus
Ink
62
217
0.04
45712
West
Hana
Paper
99
445.5
0.11
45721
North
Ivo
Pens
46
253
0.18
45730
South
Jo
Folders
83
290.5
-0.05
45739
East
Kai
Ink
30
135
0.02
45748
West
Lia
Paper
67
368.5
0.09
45757

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

Data Validation

Separate items with commas, or point at cells with = (a range or a name). Alt+↓ opens the list in a cell.

Sort

    Rows are sorted by the first level; rows that tie are sorted by the next level, and so on.

    Remove Duplicates

    Rows in count as duplicates when they match in every column you tick. The first one is kept.

    Name Manager

    No names yet. Select some cells and press New…, or type a name in the box left of the formula bar and press Enter.

    Use a name in any formula, e.g. =SUM(Prices). Ctrl+F3 opens this box.

    Edit chart

    Create Table

    A table gets a name, coloured rows, filter buttons and grows by itself when you type in the row below it. Formulas can then say =SUM(Table1[Sales]) instead of =SUM(D2:D20).

    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.

    Text to Columns

    Split the text in into separate columns.

    Delimiters

    Goal Seek

    Change one input until a formula gives the answer you want.

    Create Sparklines

    Protect Sheet

    Stop changes to Sheet1. Cells you marked with Home › Format › Lock Cell (unlocked) can still be edited.

    Practice passwords only: Excel’s sheet protection stops accidental edits, not determined people.

    Group

    Insert Function

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