1. Computing

Mixed Cell Reference

By

Using Mixed Cell References in Excel Formulas

Mixed Cell References in Excel Formulas

© Ted French
Definition:

Note: For help with this definition, see the image to the right.

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

Cell references consist of a column letter and the row number that intersect at the cell's location in a spreadsheet such as D2 or AZ234.

By default, a spreadsheet cell reference is relative. What this means is that as a formula or function is copied and pasted to other cells, the cell references in the formula or function change to reflect the function's new location.

Alternatively, an absolute cell reference, such as $F$34 or $G$67, does not change when a formula or function is copied to other cells.

A mixed cell reference then, is a combination of relative and absolute cell references.

As with absolute cell references, the dollar sign ( $ ) is used in mixed cell references to indicate that a column letter or row number is to remain fixed when a copied from one cell to another.

Examples of a mixed cell reference would be $E4 or F$6.

For $E4, the column letter is fixed while the row number is allowed to change when copied to other cells. For F$6, the row number is fixed while the column letter changes.

Note: When listing any cell reference - relative, absolute, or mixed, the column letter is always listed first.

More information can be found under Cell Reference and Absolute Cell Reference.

Related Articles

Also Known As: Mixed Cell Address

©2014 About.com. All rights reserved.