0 of 62
Getting started·Lesson 6 of 62Free

Typing values and your first formula

Typing in a cell and your first formula

What you’ll do

You can type two kinds of things into a cell: a value, like 10, or a formula, which starts with = and works out its own answer.

Your turn

Step 1 of 4
  1. 1
    Click K2, type 10 and press Enter. A typed number just sits there.
  2. 2
    You’re in K3 now. Type =E2+E3 and press Enter. The = tells Sheets it’s a formula, so it adds 3 and 8.
  3. 3
    Click K3. The cell shows 11, but the bar at the top shows the formula behind it.
  4. 4
    Make it multiply instead: with K3 selected, press Enter to edit, change + to *, and press Enter.
A1
ABCDEFGHIJK
1OrderRepRegionProductUnitsPriceOrder dateShip dateYour cells
21001AnaWestDesk32401/5/20261/9/2026
31002BoEastChair8851/12/20261/20/2026
41003CyWestLamp12301/19/20261/22/2026
51004DiNorthDesk22402/2/20262/13/2026
61005AnaWestChair5852/9/20262/12/2026
71006EveSouthShelf41202/16/20262/27/2026
81007BoEastLamp20303/2/20263/4/2026
91008CyWestShelf11203/9/20263/18/2026
101009DiNorthChair6853/16/20263/19/2026
111010EveSouthDesk72403/23/20264/1/2026
Ctrl+/ shows the shortcuts

Stuck?