| 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) | |||
Hybrid Mode
