| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Autofill only copying initial value, not filling formula
When I have tried to average columns of numbers with the formula
=Average(A1:A10). The initial value is correct, but when I try to autofill across the row to get averages for each column, it simply copies the first average. The formulas are actually correct when it fills but I need to click on the cell ranges in each individual formula for it to recalculate the averages correctly. Previously, everything was working fine. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Autofill only copying initial value, not filling formula
Toolsoptionscalculation and set calculation to automatic
-- Regards, Peo Sjoblom "dwbmd2005" wrote in message ... When I have tried to average columns of numbers with the formula =Average(A1:A10). The initial value is correct, but when I try to autofill across the row to get averages for each column, it simply copies the first average. The formulas are actually correct when it fills but I need to click on the cell ranges in each individual formula for it to recalculate the averages correctly. Previously, everything was working fine. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Autofill only copying initial value, not filling formula
Do you have manual calculation on?
Try hitting F9 to do a manual calculation this will recalc all cells at once. "dwbmd2005" wrote: When I have tried to average columns of numbers with the formula =Average(A1:A10). The initial value is correct, but when I try to autofill across the row to get averages for each column, it simply copies the first average. The formulas are actually correct when it fills but I need to click on the cell ranges in each individual formula for it to recalculate the averages correctly. Previously, everything was working fine. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying & Filling in data from One file into another. | Excel Worksheet Functions | |||
| Formula for markup won't change when the initial value is changed. | Excel Worksheet Functions | |||
| Initial Formula Calculation | Excel Discussion (Misc queries) | |||
| Copying and Filling Cell With Functions | Excel Discussion (Misc queries) | |||
| Excel 2000 filling/copying | Setting up and Configuration of Excel | |||
Linear Mode
