Forum Discussion
Solved
How do I keep a part of my formula from changing when I use my fill bar?
I am struggling to remember how to do this. I want to drag my fill bar down to copy a formula but when I do the whole formula goes down a row. For the first part of my formula i definitely want this but I want the second part of my formula to stay the same as the formula i am copying down.
- To copy down, lock the row by preceding it with Dollar Sign, like this:
=A3+A$2
When you copy down 1 row, the formula will become:
=A4+A$2
2 Replies
Hello OkkonenT99,
As a supplement to the answer provided by Twifoo, after clicking inside of a cell reference, you may use F4 to toggle between (A1, $A$1, A$1, and $A1).
- To copy down, lock the row by preceding it with Dollar Sign, like this:
=A3+A$2
When you copy down 1 row, the formula will become:
=A4+A$2
