Find a cell from its address
An address is two things joined up: the letter of the column, which runs along the top of the grid, and the number of the row, which runs down the left. The letter always comes first. C4 means column C, row 4. There is no such thing as 4C, and a cell holding 4C is just a cell holding some text.
It is worth becoming properly fluent at this, because every formula you will ever write is a sentence made of addresses. Once reading them is automatic the rest of Excel is mostly vocabulary, and until it is, every instruction feels like a puzzle before you even start.
One cell in the block of numbers holds 99. In B7, type that cell's address.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | ||||||
| 2 | 14 | 26 | 31 | 8 | ||
| 3 | 45 | 12 | 7 | 52 | ||
| 4 | 63 | 99 | 20 | 11 | ||
| 5 | 38 | 5 | 47 | 29 | ||
| 6 | ||||||
| 7 | The 99 is in cell | |||||
| 8 | ||||||
| 9 |
Click a cell and type. Enter commits, Tab moves right, F2 edits in place, Ctrl+Z undoes. Drag the small square at the corner of a cell to fill. Ctrl+Enter checks your answer.