Question

If you copy the formula =$B7 to another cell , what will be the answer

Answer 1

Answer:

The column part will remain the same

The $ put in front of the column or row row part of a cell address will freeze that part of the address. For the $B7 cell address, it's the B 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.