Absolute Cell References in MS Excel

Absolute Cell References

Situations arise in which the cell reference must remain the same when copied or when

using AutoFill. Dollar signs are used to hold a column and/or row reference constant.

Absolute Cell References in MS Excel

Summary of absolute cell reference uses:

$A1

Allows the row reference to change,

but not the column reference.

A$1

Allows the column reference to

change, but not the row reference.

$A$1

Allows neither the column nor the row

reference to change.

Example:

In the example below, when calculating commissions for sales staff, you would not want

cell B10 to change when copying the formula down. You want both the column and the

row to remain the same to refer to that exact cell. By using $B$10 in the formula, neither

changes when copied.

If my posts are useful for you، or if there is any reduction in them so kindly comment me.