What is the symbol for absolute address reference in excel?

Cells are divided into relative references and absolute references. For relative references, you can directly enter the cell name. For absolute references, just add $ in front of the relative reference, such as $A$1. However, workbooks and worksheets can only be referenced absolutely, not relative.

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

Cells can be divided into relative references and absolute references. For relative references, you can directly enter the cell name (such as A1). For absolute references, just add $ in front of the relative reference (such as $A$1, $A1 , A$1). However, workbooks and worksheets can only be referenced absolutely, not relative.

1. Relative reference, the address will change when you copy the formula. For example, there is a formula in cell C1: =A1 B1

When you copy the formula to cell C2, it becomes: =A2 B2

When the formula is copied to cell D1, it becomes: =B1 C1

2. Absolute reference, the address will not change when the formula is copied. For example, there is a formula in cell C1: = $A$1 $B$1

When the formula is copied to cell C2, it is still: =$A$1 $B$1

When the formula is copied to cell D1, it is still: = $A$1 $B$1

3. Mixed reference. When copying the formula, part of the content of the address will change. For example, cell C1 has the formula: =$A1 B$1

. When the formula is copied When it is copied to cell C2, it becomes: =$A2 B$1

When the formula is copied to cell D1, it becomes: =$A1 C$1

Related learning recommendations: excel Tutorial

The above is the detailed content of What is the symbol for absolute address reference in excel?. For more information, please follow other related articles on the PHP Chinese website!