i want to use excel for pricelists but with a facility to change profit
margins. At present I enter the proposed markup in one cell and calculate the
figure I have to use to multiply the cost price by to acheive the profit in
another cell (Cell 2). So far, so easy.

I then enter the product descriptions in one vertical list and their cost
prices in the adjoining column (Column B). To get the sales price I have to
multiply each entry in column B by the figure calculated in Cell 2, but when
I fill down the formula, the row value in Column B increases by one but so
does the reference to Cell 2.

Is there any way I can keep the cell 2 reference fixed whist changing the
rows in column B?