if you copy the formola =$C5 to another cell, what will be the result ?
Answers
Answered by
8
Answer: The column part will remain the same
Explanation:
The $ put in front of the column or row row part of a cell address will freeze that part of the address. For the $C5 cell address, it's the C column that will remain the same. This option is very practical when you wish to copy a formula but keep the same cell references. You have to think if you need to freeze the column if you wish to copy the formula horizontally. The same can be said for the row reference if you wish to copy the formula vertically.
Similar questions