Keep Formula Cell Reference Constant In Excel or Create absolute Cell References

Author: Astro    Posted: 13 February 2022   Viewed: 2882 times   Tags: #Windows 10  #Mac OS 

To keep cell reference constant in formula, you just need to add the $ symbol to the cell reference. 


When you use relative cell reference in a formula, it will automatically adjust when you use the Fill Handle to apply it to a different location or copy and paste it to another cells. . In many cases, you would like the cell reference staying constant rather than adjusting automatically. 


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:


Your Kind Action