how do I drag formulas from one column to the next

M

Miles

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?
 
R

Roger Govier

Hi Miles

It maybe that you Tools>Options>Calculation set to Manual instead of
Automatic
 
Top