Fill Down

[tom studebaker]

How do I fill down and keep the same number dividing the equation? e.g.
=A1/A10 fill down each cell to = A2/A10, A3/A10 and so on. Everytime I
fill down is goes from A1/A10 to A2/A11 etc.

 

[Domenic]

Hi Tom,

Use an absolute reference for your divisor,

=A1/$A$10

Cheers!