Forum Discussion
Always use the same cell value in a formula
How can you keep the value of a cell same in all rows while the values of the other cells in the formula change per row
Correction: How can you keep the value of one of the cells in a formula the same in all rows while the values of the other cells in the formula change per row
I think that you are referring to writing absolute references.
For that, use the dollar symbol ($).
If you want a cell to remain in the formula even if you fill down in rows or columns that formula, then type the cell as follows: $A$1. That is an absolute reference.
If you wished to only fix the row but not the columns, then it would be: A$1. If you wished to fix the columns but not the row, then it would be like: $A1.
thank you very much
