Your First Cells
Part of the Fundamentals section of Coddy's Excel journey — lesson 3 of 42.
Time to actually put something in the grid. Entering a value takes three steps: click the cell you want, type the value, and press Enter to confirm.
When you click a cell it becomes the selected (or active) cell, it gets a highlighted border, and whatever you type goes into that cell and nowhere else. This is why references matter: if the task says "put 5 in B2", you click column B, row 2, not just any box that looks convenient.
Pressing Enter stores the value and usually moves the selection one cell down, which is handy when you're filling a column of numbers one after another.
Words and numbers are both welcome. Type Hello into a cell and it stores the text; type 15 and it stores the number. In the challenge below you'll do both, the labels in column A tell you what belongs in each cell of column B.
Challenge
BeginnerThe labels in column A tell you what to type into the cell next to them in column B.
- In
B1: the wordHello - In
B2: the number5 - In
B3: the number10 - In
B4: the number15
Click each cell, type the value, press Enter. That's the whole skill, but it's the one everything else is built on.
Try it yourself
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Word | ||||||
| 2 | First number | ||||||
| 3 | Second number | ||||||
| 4 | Third number | ||||||
| 5 | |||||||
| 6 | |||||||
| 7 | |||||||
| 8 | |||||||
| 9 | |||||||
| 10 | |||||||
| 11 | |||||||
| 12 | |||||||
| 13 | |||||||
| 14 |
This lesson includes a short quiz. Start the lesson to answer it and track your progress.
All lessons in Fundamentals
1Meet the Spreadsheet
What Is a Spreadsheet?Cells and ReferencesYour First CellsRows, Columns and the GridRecap: Meet the Grid