Sorting the order of the items in an Excel AutoFilter

[bibu]

months.png

Hello. In the picture above, the column A is populated with a list of the months of the year, in chronological order. Is there any way to change the order in which the months are displayed when you click the autofilter? As it is, they are displayed in alphabetical order and I would like them to be displayed in chronological order: January - December.

I'm refering only to the order in which the items are displayed when the autofilter is clicked, and not the order of the values of the cells on the column.

Thanks in advance for your help.

[tanasedn]

Hi,
In Autofilter , on text columns the order of items is alphabetical and you can't change it. The chronological order of months appear on date columns.

[Glenn Kennedy]

Sort/Custom Sort If it's not already present, then create a new custom list as shown by the box instructions

[6StringJazzer]

a list of the months of the year, in chronological order

They are chronological in your head, but they are just a list of words to Excel, so it sorts in alphabetical order. Note that it says "Sort A to Z".

Instead of typing in text for each month, use date values

(EU format dates)
1/1/2023
1/2/2023
1/3/2023

etc.

Then using Custom Format Mmmm

You will see the same thing in the cells, but now you can sort it. Now it will say "Sort oldest to newest"

If this does not help please attach a sample file with your data.

[tanasedn]

@Glenn
I'm afraid that the OP want to see in Autofilter menu the months name in chronological order and I'm pretty sure that this is not possible.

[bibu]

Thank you all for your input. It helped me find the workaround. I simply populated the Month column with the dates from January 1st to December 31st, and then used a custom format:

months2.png

Now the months are displayed in chronological order, within the AutoFilter. TY

[Glenn Kennedy]

You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.

[bibu]

Correction: for the Months I used the same solution that @6stringjazzer offered. The workaround that I was referring to, was for the days of the week column.
Which was this:
=WEEKDAY(A1; 2)&"-"&CHOOSE(WEEKDAY(A1; 1); "Dimanche"; "Lundi"; "Mardi"; "Mercredi"; "Jeudi"; "Vendredi"; "Samedi")