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 auto...
HansVogelaar
Jul 16, 2025MVP
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.