COLUMN FORMULA

[Guest]

How do I copy a formula to an entire column without getting the same
response? I want Column K to equal Column E times Column I plus Column E but
only if there is data in the other columns. I want to copy the formula down
but when I click on the column header it just types my formula into the first
cell. I was going to each individual row and clicking on the cell and adding
the formula but I am sure there is an easier way. I would appreciate your
help!

 

[Gord Dibben]

Assuming your formula is entered in K1

Grab by left-clicking the fill handle(bottom right corner of K1) and drag down
the column to copy/increment the formula.

I also assume you have used relative references....no $ signs

Make sure Tools>Options>Calculation is set to "automatic".


Gord Dibben MS Excel MVP