Excel Help

[SAC]

I am working on a price quote for a customer and I want to multiply quantity and cost for a ext price. How do I do it for the entire column. So I dont have to retype the formula or calculate on the calculator. I have about 100 line items to total.

TIA

SAC

[WildHog]

Insert the formula into the cell of the ext price ... right click on the cell and copy formula, from line 2 / cell highlight all of the cells that you what the formula in and paste.

[SAC]

Worked. Thanks Hog.

[Texastaxi]

Either that, or highlight the one cell with the formula and you'll get a little box in the lower right hand corner of that cell. Put your cursor in the square, hold down the left mouse button and drag it down as far as you want. It'll update the formula in each cell to match that line.

[WildHog]

Not a problem, gald that I was able to help. There are multiple ways of doing this .... the copy and paste is the easiest to explain. Take care!!

[SAC]

Thanks Kev. That way was much shorter.


























Imagine that

[TexasBob]

can also just double click that box in the lower right corner. Will copy it down until there is a break.

[bearintex]

Remember that if you copy a formula, the cells that it looks for are relative to the cell the formula is in. If it's looking for a value in a cell two to the left, and you copy that formula to another column, it will still look two to the left, unless you hard reference the original cell, by adding $ in front of the column or row reference. For example- A$2 instead of A2. If you copy the A$2, it will always reference row 2, regardless of where you copy it to. Clear as mud?