| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Format as a MACRO | Excel Worksheet Functions | |||
| how can i multiply two columns | Excel Worksheet Functions | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| copy and pasting a find all list into another column | Excel Discussion (Misc queries) | |||
| Match then lookup | Excel Worksheet Functions | |||
Linear Mode
