Make it stop!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

asdfqwerty - 11 Oct 2004 20:24 GMT

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

Reply to this Message

Frank Kabel - 11 Oct 2004 20:39 GMT

Hi
use absolute references. See:
http://www.cpearson.com/excel/relative.htm

Signature

--
Regards
Frank Kabel
Frankfurt, Germany

> I didn't used to mind that Excel would automatically change my

formulas

> during a cell copy/paste, but I'm starting to work with some really
> long formulas with several cell references in each, and I'm doing a

lot

> of coyping and pasting. It's really getting tiresome having to

manually

> revert every formula that I don't want changed, and it would possibly
> save me hours of work if I could make it so that these automatic
[quoted text clipped - 6 lines]
> asdfqwerty's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=15187
> View this thread: http://www.excelforum.com/showthread.php?threadid=268266

Reply to this Message

Jack Schitt - 11 Oct 2004 20:44 GMT

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

Signature

Return email address is not as DEEP as it appears

>
> I didn't used to mind that Excel would automatically change my formulas
[quoted text clipped - 5 lines]
> formula updates didn't occur with every single paste that I made. Is
> there any way to turn off these automatic changes?

Reply to this Message