Autofill

[reese]

How do use autofill to increment one reference in a
formula without affecting the other?

Example =h8/h6 =h9/h6 =h10/h6

When I auto fill both "H's" are incremented.

Any help would be appreciated

 

[Peo Sjoblom]

=H8/$H$6

 

[JohnI]

reese,

If you want just the "6" to remain constant

=H8/H$6

If you want both "H" & "6" to remain constant

=H8/$H$6

The $ before the symbol, forces it NOT to change!

regards,

JohnI

 

[Tami]

You used $ signs to indicate which cell reference is
absolute.
In response to your example below, the formula would be
=h8/$h$6
When you use auto fill, the reference to h8 would change
but the reference to h6 would remain constant.