Question

How will you create a series of months in MS-Excel?​

Answer 1

Answer:

To auto generate a series of days, weekdays, months or years with a specific step, this is what you need to do:

Enter the initial date in the first cell.

Select that cell, right-click the fill handle, drag it through as many cells as needed, and then release.

In the pop-up menu, choose Series (the last item).