Cell References

Cells are named in Excel by their columns and rows. The columns are named with letters and the rows with numbers, as in the screen shot below:

In this screenshot, we have highlighted column C and row 4; where they meet is called cell C4. (This highlighting will not appear in Excel, although you can choose to change the background color of certain cells if you like.)

You can also specify a range of cells by listing the cell in the upper left hand column, followed by a colon and the cell in the bottom right hand column. The screen shot below shows the cells in the range C2:E3 selected:

Cell references are primarily used in writing formulas.

Return to Excel Guide