Autofill

[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.

 

[Frank Kabel]

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