Autofill

  • Thread starter Thread starter Neuther
  • Start date Start date
N

Neuther

How do i get it to stop auto filling.

i have a formula =H35/VLOOKUP(B3,B64:H66,7,FALSE)
in the next cell i want =H36/VLOOKUP(B4,B64:H66,7,FALSE)

but it want's to auto fill it and go =H36/VLOOKUP(B4,B65:H67,7,FALSE)

is there a way for me to get it to stop adding 1 to the b64 and b65.
It would be coolest if i could get the h35 and the b3 to increse by 1
but not the rest of the formula. If i can't get it to do that i would
like it if i could copy and paste the whole thing and just change the
h35 by hand.
 
Hi

change your formula to
=H35/VLOOKUP(B3,$B$64:$H$66,7,FALSE)

The '$' sign will create an absolute reference which is not changed by
copying the formula. Easiest way to toggle between absolute and
relative reference is hitting the F4 button

Frank
 
Back
Top