What are the ways to reference cells?

There are three ways to reference cells, namely: 1. Relative reference, based on the relative position of the cell containing the formula and cell reference; 2. Absolute cell reference always refers to the cell at the specified location. Grid; 3. Mixed references have absolute columns and relative rows, or absolute rows and relative columns.

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

There are three ways to reference cells, namely:

1, Relative reference: in the formula Relative cell references are based on the relative position of the cell that contains 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.

2. Absolute reference: An absolute cell reference in a cell always refers to the cell at the specified location. 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.

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.

Extended information:

If the cell formula is "= A1 B1", it is a relative reference. When using relative addresses, the reference address in the cell formula will change accordingly as the target cell changes, but the relative address between its reference cell addresses remains unchanged.

The cell address consists of two parts: the letter part represents the column number; the numeric part represents the row number. The $ symbol indicates an absolute reference. Adding $ before a letter indicates an absolute reference to a column. Adding $ before a number indicates an absolute reference to a row. Adding both indicates an absolute reference to the cell.

Related free learning recommendations: Programming video

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