What are the three types of excel cell references?

What are the three types of excel cell references?

The reference to the cell address in the EXCEL formula includes relative There are three types: reference, absolute reference and mixed reference. The shortcut key for switching between the three modes is the function key F4 on the top row (some new laptops require Fn F4).

Recommended: "excel tutorial"

1. Relative reference

The relative cell reference (such as A1) in the formula is based on the formula containing the formula and The relative position of the cell referenced by the cell. If the location of the cell where the formula is located changes, the reference changes as well. If you copy a formula across multiple rows or columns, references automatically adjust. By default, new formulas use relative references. For example, if you copy a relative reference in cell B2 to cell B3, it will automatically adjust from =A1 to =A2.

2. Absolute reference

The absolute cell reference in a cell (for example, $F$6) always refers to cell F6 at the specified position. If the position of the cell containing the formula changes, the absolute referenced cell always remains the same. If you copy a formula across multiple rows or columns, absolute references will not be adjusted. By default, new formulas use relative references, they need to be converted to absolute references. For example, if you copy the absolute reference in cell B2 to cell B3, it will be the same in both cells, $F$6.

3. Mixed reference

Mixed reference has absolute columns and relative rows, or absolute rows and relative columns. Absolute reference columns take the form $A1, $B1, etc. Absolute reference lines take the form A$1, B$1, etc. If the position of the cell where the formula is located changes, the relative reference changes, but the absolute reference does not change. If you copy a formula across multiple rows or columns, relative references automatically adjust, while absolute references do not. For example, if you copy a mixed reference from A2 to B3, it will be adjusted from =A$1 to =B$1.

The above is the detailed content of What are the three types of excel cell references?. For more information, please follow other related articles on the PHP Chinese website!