Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Autofill Formula
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Autofill Formula
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 "caliberprops" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofill Formula | Excel Worksheet Functions | |||
Is it possible? | Excel Worksheet Functions | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Autofill Formula | Excel Discussion (Misc queries) | |||
Question about Autofill with a formula | Excel Discussion (Misc queries) |