Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I drag formulas from one column to the next
I have 20 columns or more of data that I want to perform the same
calculations on but when I drag the first box sometimes I can get it to drag the formula but more times than not it just drags the result of the first column to all subsequent comumns. I don't understand Excell much but I'm curions as to why this works sometimes and not others? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I drag formulas from one column to the next
Hi Miles
It maybe that you ToolsOptionsCalculation set to Manual instead of Automatic -- Regards Roger Govier "Miles" wrote in message ... I have 20 columns or more of data that I want to perform the same calculations on but when I drag the first box sometimes I can get it to drag the formula but more times than not it just drags the result of the first column to all subsequent comumns. I don't understand Excell much but I'm curions as to why this works sometimes and not others? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Complicated insert / drag formulas | Excel Discussion (Misc queries) | |||
Formulas won't drag down the column | Excel Discussion (Misc queries) | |||
How do i drag formulas down | Excel Discussion (Misc queries) | |||
drag and drop formulas | Excel Discussion (Misc queries) | |||
how can I drag formulas with other cell references | Excel Discussion (Misc queries) |