Related Tutorial: Using Cell References in Excel Formulas
In Excel, a cell reference identifies the location a cell or group of cells in the worksheet.
Note: When listing a cell reference, the column letter is always listed first - such as A1 or W345.
While references usually refer to individual cells - such as A1, they can also refer to a group or range of cells.
Ranges are identified by the cell references of the cells in the upper left and lower right corners of the range.
The two cell references used for a range are separated by a colon ( : ) which tells Excel to include all the cells between these start and end points.
An example of a range of adjacent cells would be B5:D10.Related Terms