Forum Discussion
JimJones
Jul 16, 2025Copper Contributor
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.