I'm claculating percents of gross sales, and I want to be able to create a
column which takes the value of all the cells in my P&L and divides them by
gross sales. For example: (x/y), (x+1)/y, (x+2)/y, etc. When I try and
copy the original formula, I get x/y, (x+1)/(y+1), (x+2)/(y+2), etc. Where
y=gross sales, I want the denominator to remain a constant reference to a
given cell. I know it's got to be an easy fix, I just can't find it anywhere.

Thanks for your help.