Computer Training & Application Solutions made Simple
Contact us for a free consultation
  • Click to send us an email. We'd love to hear from you!   Ottawa       613-656-4229
  • Click to send us an email. We'd love to hear from you!   Montreal    514-342-9494

Sorting by Month in Microsoft Excel

By Deborah J. Sparks


"Is there any way to sort by month instead of alphabetically?"


Absolutely - use the sort option below.


Have you ever tried to sort months that you've entered in a column or row and ended up with April before January? Here's the solution:

  • Click anywhere within your data
  • Data menu, Sort option
  • Click the Options button
  • Select the full or abbreviated months from the First key sort order list

Notice you can also use the sort options to sort horizontally instead of vertically.

More Newsletter Articles

© 2009 DJH Training & Application Solutions Inc.

WOULD YOU LIKE TO USE THIS ARTICLE IN YOUR NEWSLETTER, EZINE OR WEB SITE? You can, as long as you include this complete blurb with it: An entrepreneur at heart, Deborah J. Sparks established DJH Training & Application Solutions Inc. over 20 years ago, realizing her dream of creating a company known for providing high quality computer software training, application development and support and exercising her passion for teaching. To learn more and to register for DJH's free newsletter, Innovations, please visit