How to Fill Cells Down by Month

- How to Fill Cells Down by Day
- How to Fill Cells Down by Workday
- How to Fill Cells Down by Year

To fill cells down by month, please follow the steps below for details:

Step 1: Select the range with the dates on the top;

Step 2: Click the "Home" tab from the ribbon;

Step 3: Click "Fill" in the "Editing" section, and "Series" from the drop-down list;

Step 4: In the "Series" window, click "Columns", "Date" ,and "Month", then type a step number (e.g., 1) in the box; you can also make a stop number in the "Stop value" box, if necessary.

Step 5: The data range is filled by the month.

Leave a Reply