I have been searching on the internet for hours trying to find a solution for this.
I have seen many similar posts but doing the suggested has not been able to fix my own problem yet.
I want to be able to use drag-and-drop to have Excel automatically fill the lower cells in increments.
For example I enter:
When I drag the fill handle I want to get:
What I get:
Basic PC specs:
I have Windows 7 and Microsoft Office 2007.
This spreadsheet was able to do this previously.
I can still drag-and-drop in increments on other sheets in the same workbook.
Other computers are also unable to make this spreadsheet's drag-and-drop function to automatically increment values.
What I have tried so far:
1. Select two cells and drag the fill handle.
2. Hold ctrl and drag the fill handle.
3. Went to "Excel Options", selected "Advanced" and made sure "Enable fill handle and cell drag-and-drop" was enabled.
4. Went to "Formula" tab, selected "Calculation Options" and made sure it was set to "Automatic"
The above have fixed the problem for other users but this has not yet fixed my own issue.
I have tried everything I can find on the internet so far.
Any additional methods would be greatly appreciated.