Fill row or column with a series of data

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

1. Type data in the worksheet as below.

   

2. 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.

3. In the Series dialog box, set Direction to Down, Type to Linear, Step Value to 7, and Stop Value to 31.
4. 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.