Forum Discussion
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...
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.