Hello all. Sorry if I am posting this question in the wrong category, but
this is my first post here.

I am using Excel 2007, and I am trying to automatically copy a formula
that's in a column when I add a new row. I'll explain a little more in
detail what I am hoping to achieve.

My spreadsheet is intended to show profit and loss for my sales. Columns
A:W all have details specific to the products that I am selling, including
original purchase price, sale price, shipping, fees, etc... In Column X, I
have this formula " =SUM(Q4:W4)*L4 ", and then in Column Y, I have this
formula " =SUM(R4:W4)+(Q4*L4)-(K4*L4) ". Both formulas work with the
information I have in this spreadsheet for what I am wanting them to do, but
I would like to take it a step further.

Each row represents an item that I am selling, and I am selling more
products more frequently (thankfully) so I want to automate the calculations
in columns X & Y. I do know how to copy a formula by using the CTRL + C and
CTRL + V, and the fill function in excel, but I have different colors and
fonts for specific items, and I don't like have to repair that once I copy
the formula.

Is there a way to do what I want? I tried copying the formula starting at
X1 and ending at X1000 just to see how that would do, but when I went to
print my spreadsheet, it was printing 50 pages of ' $ - ' in the columns b/c
there were no figures to calculate the formula.

Any help that I can get would be GREAT! I appreciate all the help.

Thanks.