Always use the same cell value in a formula

Copper Contributor

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

2 Replies
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

@PaulKortman 

 

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.