To preserve an exact cell address in a copied formula,you can use a relative cell reference.

Name: To preserve an exact cell address in a copied formula,you can use a relative cell reference.
Brand: Quizplus
Rating: 4.8 (35 reviews)

Question

Quizplus · Accepted Answer

To preserve an exact cell address in a copied formula, you need to use an absolute cell reference by adding a dollar sign ($) in front of both the column and row reference ($A$1). A relative cell reference will change automatically when the formula is copied to another cell.

To Preserve an Exact Cell Address in a Copied Formula,you