Make it stop!

  • Thread starter Thread starter asdfqwerty
  • Start date Start date
A

asdfqwerty

I didn't used to mind that Excel would automatically change my formula
during a cell copy/paste, but I'm starting to work with some reall
long formulas with several cell references in each, and I'm doing a lo
of coyping and pasting. It's really getting tiresome having to manuall
revert every formula that I don't want changed, and it would possibl
save me hours of work if I could make it so that these automati
formula updates didn't occur with every single paste that I made. I
there any way to turn off these automatic changes
 
Prefix with a "$" (dollar) symbol any Column reference and any row reference
that you do NOT want to change when copying the formula.

Thus, the formula
=$A$1 will return the value of cell A1, and the formula will remain
unchanged when you copy that formula to another cell.

=$A1 will do the same, but when you copy it the "A" will remain the same but
the "1" will vary relative to the position to which you are copying.

=A$1 will anchor the "1" so that the row reference remains unchanged, but
the column reference will change.

etc
 
Back
Top