Autofill

  • Thread starter Thread starter reese
  • Start date Start date
R

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
 
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
 
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.
 
Back
Top