Dividing by Same Cell

[MJohnson]

Hi,

I know this is simple, but I can't seem to remember how
to do it....

I want to copy down a formula where the top part of the
equation is changing and the bottom part remains the same.

Example: A1/A6
A2/A6
A3/A6

If I copy down my formula now I get the following:

A1/A6
A2/A7
A3/A8
etc.

How do I fix this so I don't have to manually do each
formula.

Thanks so much!

 

[Don Guillett]

try
=a1/$A$6

 

[Frank Kabel]

Hi
use
=A1/$A$6

you may have a look at:
http://www.cpearson.com/excel/relative.htm