Let's say you want to have these formulas in column D. In D8, enter:
=c8/$c$6

Now fill this down the column. The $ tells Excel not to change the cell
reference.

Regards,
Fred.

"LRM" wrote in message
...
I have cell c6 that needs to be divided by c8/c6, c9/c6, c10/c6 and so on.
How can I come up with a formula without having to manually enter it each
time. I have hundreds of rows of data to do this with.
Thanks
LRM