What are the ways to reference cells in excel?

The cell reference methods of excel are: 1. Relative reference, which is based on the relative position of the cell containing the formula and cell reference; 2. Absolute reference, the specified position refers to cell F6; 3. Mixed reference , with absolute columns and relative rows, or absolute rows and relative columns.

The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

The cell reference methods of excel are:

1. Relative reference

Relative cell reference in formula ( For example A1) is based on the relative position of the cell containing the formula and cell reference. 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 references

Mixed references have 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.

Related learning recommendations: excel tutorial

The above is the detailed content of What are the ways to reference cells in excel?. For more information, please follow other related articles on the PHP Chinese website!