Service mondial
ou
Votre partenaire dans la formation aux logiciels et le développement d'application
depuis plus de 25 ans
Microsoft Excel articles et conseils
© 2009 DJH Training & Application Solutions Inc - Updated 2022
QUESTION: I have a column of months, but when I try to sort them chronologically, I end up with them in alphabetical order, with April before January. How can I sort them correctly?​
​
ANSWER: Full and abbreviated months are included automatically in Excel Custom Lists. We will use one of the month choices to sort correctly:
​
-
Click in a single cell in your data, then click the Sort button on the Data tab > Sort & Filter group.
Hint: Right-click the Sort button to add it to your Quick Access Toolbar
2. Select the column that contain the months in the Sort by drop-down, then select Custom List... from the Order drop-down
3. Select the abbreviated or full month name list from the Custom lists options, depending on which matches your data, and click OK.