Forum Discussion

JimJones's avatar
JimJones
Copper Contributor
Jul 16, 2025

Auto-fill not working

Hi. I am trying to fill a series of dates in excel to advance weekly but when I use the drag handle at the bottom of the cell it keeps the same dates but changes the year. Where there used to be autofill options offered  im only getting a dialogue box with formatting/chart/totals/ tables none of which helps me format autofill.

I have autofill option turned on. The file is saved to my onedrive folder on my computer

Thanks in advance for help

1 Reply

  • Use the right mouse button to drag the fill handle.

    When you release it, you should see a popup menu. Select Series...

    Make sure that Day is selected, and enter 7 in the Step value box:

    Click OK.

Resources