Enter the initial date in the first cell.To auto generate a series of days, weekdays, months or years with a specific step, this is what you need to do: When you release the mouse button, a context menu will pop-up letting you select the needed option, Fill Years in our case:įill a series of dates incrementing by N days Or you can enter your first date, right-click the fill handle, hold and drag through as many cells as needed.After that, click the AutoFill Optionsbutton and pick the desired option, say Fill Months:
Fill a column with sequential dates as described above.To create a series of workdays, months or years, do one of the following: Select the cell with the initial date and drag the fill handle (a small green square at the bottom-right corner) down or to the right.Įxcel will immediately generate a series of dates in the same format as the first date that you typed manually.įill a column with weekdays, months or years.Type the initial date in the first cell.Auto fill a date series in Excelįilling a column or row with dates that increment by one day is very easy: When you need to fill a column with dates in Excel, the fastest way is to use the AutoFill feature.
0 kommentar(er)
