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 ...
- 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
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
=A3+A$2
When you copy down 1 row, the formula will become:
=A4+A$2