"lock" fields so they don't change number while copying formulas?

M

MrHaugen

I just can't get this straight.

Every time I copy a formula there are lots of reference fields on page
1 that I want to increase numbers, but the "static" information I got
on page 2 I want to lock so they do NOT increase.

I have about 6 of this in many of my formulas and I'm not exactly happy
to change this in fields from A1 to P40 :eek:

Any suggestions more than welcome!
 
M

mrice

Not sure that I've understood correctly but have you tried using the $
sign to make the addresses in your formulae absolute as opposed to
relative?

e.g. A1 becomes $A$1
 
Top