How to Sort Months Chronologically in Excel (With Example)

To sort months chronologically in Excel, you can use the Custom List option within the Sort feature in Excel.

The following example shows how to use this option to sort months chronologically in Excel.

Example: Sort Months Chronologically in Excel

Suppose we have the following dataset that shows the total sales made by some company during each month of the year:

Notice that the rows are currently not in chronological order based on month.

To order the months in chronological order, highlight the cells in the range A1:B13, then click the Data tab along the top ribbon, then click the Sort button.

In the new window that appears, click the Add Level button in the top left corner, then under Column choose Month and under Order choose Custom List:

sort months chronologically in Excel

In the new window that appears, click the option under Custom lists that starts with January, February, March and then click OK:

Then click OK once more:

Once you click OK, the rows in the dataset will automatically be sorted in chronological order by month:

Notice that the months are now in chronological order starting with January, then February, then March, and so on.

Note: If your dataset contains abbreviated month names such as Jan, Feb, Mar, etc. then you can choose the option under Custom Lists that starts with Jan, Feb, Mar instead.

Additional Resources

The following tutorials explain how to perform other common tasks in Excel:

How to Calculate Sum by Date in Excel
How to Calculate Average by Date in Excel
How to Add Months to Date in Excel

Leave a Reply

Your email address will not be published. Required fields are marked *