To freeze a cell reference so that it doesn't change when copied in Excel, you use the dollar sign ($) in front of the column letter and the row number. For example, if you want to freeze the reference to cell A1, you would write it as $A$1. This makes both the column and the row absolute, preventing them from changing when the formula is copied to another cell. You can also make just the row or just the column absolute by using the dollar sign accordingly (e.g., $A1 to freeze the column only, or A$1 to freeze the row only).
You freeze the total cell so that it doesn't change when copied by putting what symbol in front of the letter and number that represents the cell position.?
1 answer