Site icon ExcelNotes

How to Fill Cells Down by Workday

How to Fill Cells Down by Day
How to Fill Cells Down by Month
How to Fill Cells Down by Year

To fill cells down by workday, 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 "Workday", 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 workday.

Exit mobile version