You can fill in values by using the Data Series dialog box to specify how to fill with continuous values.
Steps
To fill with numbers with a specific interval
- Type data in the worksheet as below.
- Select the area you want to fill and select Home > Fill > Series.
Or right click, drag AutoFill handle to designate the area you want to fill, and release mouse button to open AutoFill list, and select Series.
- In the Series dialog box, set Direction to Down, Type to Linear, Step Value to 7, and Stop Value to 31.
- The month's date for Mondays will be entered. Values that exceed the stop value will not be entered even if there is room in the selected area.