skip to Main Content
Excel’s April Fools Jokeor How To Sort Month Names In Excel

Excel’s April Fools joke
or How to sort month names in Excel

If you sort a list of month names in Excel, will January or April be first? No fooling, April is the first month, alphabetically. So, if you are not careful, sorting a list of month names may not get you what you wanted. You can however follow these steps to ensure that the list is sorted in proper calendar order.

First, select your list of month names.

Second, on the ribbon’s Home tab, click Sort & Filter, then click Custom Sort….

 

Third, click the down arrow in the Order column and chose Custom List….

 

Fourth, in the Custom Lists dialog box, choose January, February, March, April.  Then, click OK to close the Custom Lists dialog box.

 

Finally, click OK to close the Sort dialog box.

TechMentors loves a challenge.  If you have a challenging question about Excel or some other Microsoft 365 application, please share it with us.

This Post Has 0 Comments

Leave a Reply

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

Back To Top