Autofill Formula

[Guest]

I used to be able to enter a formula into a cell, then select that cell and
drag it down the column and the formula would update as you would drag.
Evidentally, my system updated and changed my settings. Now if I select the
cell and drag it just copies the formula exactly and doesn't do it in a
series like before. How do I change this back?

 

[Guest]

If you post your formula, we'll have a better idea of what you're dealing with.

For instance, if your formula contains dollar signs ($), they prevent the
references from changing as you drag the formula

Example:
B1: =$A$1
If you drag that formula from B1 to B2, the formula in B2 will be =$A$1

BUT
with B1: =A1
If you drag THAT formula from B1 to B2, the formula in B2 will be =A2

Alternatively,
if Calculation is set to Manual, the formula references (without dollar
signs) change appropriately when you drag, but the displayed value won't
change until you recalculate.
If that's the problem:
<tools><options><calculation tab>
Check: Automatic

Does that help?
***********
Regards,
Ron

XL2002, WinXP