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?

Answer 1

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

Answer 2

Is the field formatted as number? If not, then I believe that is what would cause it not to increment it as normal.