Autofill

S

sneeky

When I use Autofill to copy down formula, it shows the
result od the copied cell in the new cell. But when you
click on the cell it shows the correct formula in the
Formula Bar. So basically the formula is correct and has
been copied, but the result that is displayed is from the
above cell.
I have tried pretty much most things to try and sort this
out, with no luck. Any suggestions?
 
A

Andy B

Sneeky

Check that Calculate is set to Automatic in Tools / Option / Calculation

Andy.
 

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

Formula doesn't copy correctly 1
VLOOKUP and AutoFill 5
autofill down won't work!!!! 3
autofill results appear as "$ -" with no error, why? 2
Autofill only copying initial value, not filling formula 2
AutoFill w/formulas 1
Copying formulas from one cell to another 7
Fill formulas into adjacent cells does not take formula only data 1

Top