The Cell addresses guide
A cell address is the column letter followed by the row number. C6 is the cell where column C meets row 6. The letters run along the top of the grid, the numbers down the left, and the Name box shows the address of the selected cell.
Letter first, then number
Columns are lettered A, B, C… and after Z they carry on with AA, AB. Rows are numbered from 1. An address always puts the column first: B3 is column B, row 3, never "row B". Formulas use the same addresses, so =C6*2 means "the value in C6, times two".
Count the sheet's rows, not the list's
Row numbers belong to the sheet. If a list starts under a title and a blank row, its first item might be in row 4, so the third item is row 6. When someone says "the price in C6", look at the row number on the left edge of the grid, not at how far down the list it is.
Two ways to get there
- Click it. Follow the column letter down and the row number across.
- Type it in the Name box, the box left of the formula bar, and press Enter. This is the quick way on a big sheet, and it works for ranges too: type
C2:C40.
Common mistakes
- Swapping the two. F3 and C6 are different cells. Letter first.
- Counting rows of the data. Titles and blank rows above the list still have numbers.
- Mixing up the reference style. In the rarely used R1C1 style, set in Excel's options, addresses read row first: R6C3 is C6. Column letters along the top mean the usual A1 style is on.
FAQ
- What is a cell address in Excel?
- The column letter followed by the row number, like B3 or C6. It says where the cell is, and formulas use it to point at the cell.
- Does the row or the column come first in an Excel cell reference?
- The column. B3 is column B, row 3. Only the R1C1 reference style, which you have to turn on in Excel's options, puts the row first.
- Where does Excel show the address of the selected cell?
- In the Name box, to the left of the formula bar. You can also type an address there and press Enter to go to that cell.



































































