Excel auto fill repeating the same number

Question

I'm taking the difference of some figures and having trouble amending the figures to reflect what the formula is doing (screenshot below). The autofill function is repeating the same number for the first formula.

Is there a way to autofill in the usual manner where the numbers are not repeated?

Solution

The sheet calculations are probably set to manual. You can press F9 to do it manually or turn in automatic calculations.

To turn on automatic do the following:

Click the File tab, click Options, and then click the Formulas category. Do one of the following:

1. To recalculate all dependent formulas every time you make a change to a value, formula, or name, in the Calculation options section, under Workbook Calculation, click Automatic. This is the default calculation setting.
2. To recalculate all dependent formulas — except data tables — every time you make a change to a value, formula, or name, in the Calculation options section, under Workbook calculation, click Automatic except for data tables.
3. To turn off automatic recalculation and recalculate open workbooks only when you explicitly do so (by pressing F9), in the Calculation options section, under Workbook Calculation, click Manual.

Note: When you click Manual, Excel automatically selects the Recalculate workbook before saving check box. If saving a workbook takes a long time, clearing the Recalculate workbook before saving check box may improve the save time.

Source

Comments

[CharlieRB]

Is auto calculation turned on? If not, did you press F9 to update the calculations?

[CharlieRB]

You're welcome. If that is the suitable answer, please accept it by click the check mark on the left under the vote count.

[phg]

It's formatted as Number, still the same issue.

[gregg]

This old question already had an accepted answer so new response are generally not needed