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

  • Thread starter Thread starter MrHaugen
  • Start date Start date
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!
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

locking part of look up formula 2
Copy and paste a formula in a locked cell 1
Excel Help to copy information from one row at a time to another sheet 1
Copying formulas by scrolling 1
copy formula - keep cell same but increment sheet numbers 5
Dynamic Excel data into locked Word form 0
Excel Copy COUNTIF while retaining reference 7
Copying a formula with an increase of more than 1 6

Back
Top