Turn off auto format - copy & pasting cells w\ formulas

**Bafa** · 07-09-2008, 05:33 PM

I have been reading the help files, going thruogh every option,
and every possible thing I can thing of to find out how to stop
excel from changing my formula when I copy from one cell and
past to the next.

I want to copy column cells D4:D34 and paste them into E4:E34
with no change. I want it to be exactly the same. Excel seems
tho thing is okay to modify it for me and its driving me crazy.

When I copy the D4 formula of =SUM(Over!A1:A31)
and past it to E4 it auto changes to =SUM(Over!B1:B31)
I want it to read the same though. I need it to say exactly
=SUM(Over!A1:A31)that way i can do an auto replace and change
the word Over to Under. I have several colums to do this with.

I have a headache now and just realized I have spent 2 hours
looking for the answer. So mad. Please help?

Thanks so much anyone. I know the answer will be simple and
I will have to go bang my head on the wall. Sock it to me.

**VBA Noob** · 07-09-2008, 05:38 PM

Try

=SUM(Over!$A$1:$A$31)

Select the formula and press F4 to add the $ symbols

VBA Noob

**Bafa** · 07-09-2008, 06:05 PM

lol nice. Whats funny is today as I was researching some other stuff I am truing to do I was wonder, "Why do some formulas have '$' and others don't... they seem to do the same thing...."

Anywho thanks for the tip. I am so sad I spent so long looking for the answer.

I guess the only benifit is I will *never* forget that tip.