COLUMN FORMULA
 

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!

COLUMN FORMULA
 

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 ToolsOptionsCalculation is set to "automatic".


Gord Dibben MS Excel MVP


On Wed, 8 Nov 2006 14:49:02 -0800, kcadmin
wrote:

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!