Question

Excel sorting

In excel how do you sort a column of months in ascending order and not alphabetical when the month is in word format?

Answer 1

Sort List Of Data By Month Name With Sort Function

To sort the data by month name from Jan to Dec, you should do as this:

1. Select the data range that you want to sort by month name, and click Data > Sort, in the Sort dialog box, do the following operations:

(1.) Under the Column section, please select the column name that you want to sort based on;

(2.) Choose Values from the Sort Ondrop down;

(3.) Then click Custom List from the Order drop down.

2. And it will go to the Custom Listsdialog box, in the Custom Lists box, please select Jan, Feb, Mar…list, (Note: If your month names are full names, please select January, February,… )

3. And then click OK > OK buttons to close the dialogs, now, the data has been sorted by the month name in chronological order but not alphabetical, see screenshot: