Keep Formula Cell Reference Constant In Excel or Create absolute Cell References
Author: Astro Posted: 13 February 2022 Viewed: 2929 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:
