dragging formula

M

mary kay dougherty

I have a small formula that wont drag down
the column. The answer of the formula is what is
dragging. How do I fix this so I have the correct answer
in each cell?

=left(a3,5)
 
A

Andy B

mary

Are you getting an error? What happens when you try and do it? Are the cells
blank afterwards? Is the worksheet/cell protected?
The formula looks fine. If you are dragging by the little black cross in the
bottom right hand corner of the cell, there should be no problems.

Andy.
 
G

Gord Dibben

Check Tools>Options>Calculation to see if "Auto" is enabled.

Gord Dibben XL2002
 
D

Dave Peterson

I'd check to see if calculate is set for automatic:
Tools|Option|Calculation Tab
(it sounds like it's set for manual)
 
Top