What is the symbol used to identify a cell address as an absolute address?

The symbol used to identify the cell address as an absolute address is the "$" symbol. For example, "$A$1" represents the cell that intersects the first row of column A. This cell is an absolute position.

The operating environment of this article: Windows7 system, Microsoft Office Excel2003, Dell G3 computer.

What is the symbol used to identify the cell address as an absolute address?

The symbol used to identify the cell address as an absolute address is the $ symbol.

"$" is the symbol of absolute position:

For example: $A$1 represents the cell that intersects the first row of column A. This cell is an absolute position.

$B56 represents the cell that intersects the 56th row of column B, but only column B is an absolute column.

C$25 represents the cell that intersects the 25th row of column C. Row 25 is an absolute row and column C is a relative column.

Absolute position is irreplaceable.

Recommended study: "Excel Tutorial"

The above is the detailed content of What is the symbol used to identify a cell address as an absolute address?. For more information, please follow other related articles on the PHP Chinese website!