autofill problem

D

David

Hi anyone

I have a problem with autofill on excel 2002 and excel 97
i am running them both on different computers and i have the same problem.

When i try to autofill a column using a formula (eg =F4*25) the formula
fills properly but the value in each box comes up the same as the first value
until i double click and press enter in the individual boxes.

I have no idea what to try.
David
 
K

Ken Wright

Tools / Options / Calculation / Change manual to automatic.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :)
------------------------------­------------------------------­----------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I edit the default column autofill formula? 0
hidden rows and autofill troubles 0
Formula autofill to cells below – formula arguments are cell areas in different columns 1
autofill down won't work!!!! 3
Word macro that can call cells out of Excel for a find and replace 0
Excel 2010 autofill dates not correct progression 3
Flexible autofill in macro 2
autofill from query not staying 0

Top