Excel Tip: Month Name Sorting in Excel July 14th, 2014

Vinod Kumar

In my previous article Excel Tip: Month Name Sorting with PowerPivot / PowerView, I wrote about sorting of month name inside PowerPivot. I got a number of ping about the same functionality inside standard Excel sheets. I thought this would be the easiest and known to many – but to my surprise, not all know about the capability of Excel. So in this post, let me take you through the same process for Excel tables.

So let me prep you with the data first. I have two columns Month Name and Sales. When I try to sort by the Month Name, you can see how the sorting happens for A-Z and for Z-A. It is nowhere near to what one would expect to sort as month.

That bring us to an interesting option. It has been there all along, select the “Sort by Color” –> “Custom Sort…”.

This comes up with a small dialog which I am sure most of you would have used. There right at the order dropdown, is a hidden gem called as “Custom List…”. Select this to see the magic.

This bring a standard set of list or feel free to define your own New List for sorting and build the table.

Click on “OK” and see. This is awesome because now the list is sorted automatically back in your table. Now if we sort A-Z and Z-A to see the difference. So how easy and cool is it? Have you ever used this option before, let me know.

Tags: , , , , , , , , , ,

This entry was posted on Monday, July 14th, 2014 at 08:30 and is filed under Technology. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

5 Responses to “Excel Tip: Month Name Sorting in Excel”

  1. […] Transactional Replication 5 Part Series – Data Analysts Toolkit (PowerBI and R) Excel Tip of the Month – Name Sorting In Excel […]

  2. Nakul Vachhrajani says:

    Awesome trick! I have never used this because I just learned how to achieve this custom sort. It has to be one of the most underappreciated features of Excel.

    Thanks for sharing!

  3. Ram says:

    Ah, that’s a nice nifty hack! Do these lists persist across workbooks/sessions, Vinod?

    • Vinod Kumar says:

      List is available per Excel Workbook. If you create your own custom List, those are available across workbooks and worksheets that you can use.

Leave a Reply