1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Cell Reference

By

Cell References in a Formula

Cell References in a Formula

© Ted French
Definition:

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.

Sometimes referred to as a cell address, a cell reference consists of the column letter and row number that intersect at the cell's location.

Note: When listing a cell reference, the column letter is always listed first - such as A1 or W345.

Cell references are used in formulas, functions, charts, and other Excel commands.

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
Also Known As: Cell Address

©2014 About.com. All rights reserved.