Perhpas I am an idiot, but I could not find this in the online help anywhere.
Maybe someone has conquered this problem. I want to do a fill down command,
but use a single cell as a multiplier for each line. For example, I want to
calcuate a value across a row, with a number in the final cell column of that
row. Then I want to add a calculation that will multiply the number in that
cell by a number in a single cell somewhere else on a sheet (profit margin
calculation). When I do a fill down it keeps trying to use the value in the
cell below the single cell:

=(L11*M6)
=(L12*M7)
=(L13*M8) and so on.

I just want them all to read

=(L11*M6)
=(L12*M6)
=(L13*M6)

But still be able to use the fill down as sometimes these columns get quite
large.
Thanks,