Microsoft Outlook and Windows File Explorer can sort data on more than one column
In Outlook, you can sort the display of emails on any column simply by clicking on the column name – eg clicking on “Subject” above the column of the email subject headings will sort on that column. Clicking on it again will sort in the opposite direction (eg going from A-Z and vice versa). You can click on the name of any column that is visible and Outlook will sort on that column.
But what happens if you want to sort on two – or more – columns?
For instance, I have many different backup routines, each of which sends me an email when it completes. I have a “rule” in Outlook that automatically puts all these emails in a single folder. Now, it would be just too tedious to bother actually reading all these emails every day and checking that one is received every day that one should be received, so I want a simple way of sorting the emails so that all emails with the same name (ie the same backup routine) come together in the listing and that they are further sorted so that newer emails are listed above older ones. It is then simple to cast an eye down the list of emails from time to time to see when backups did (or didn’t) happen (see illustration below).
There must be many instances where a sorting of one column within another such as this would be useful. In the above example, the emails are sorted on Received (descending) within Subject (ascending), but any combination, involving up to four sort levels, is possible in Outlook.
To sort the contents of an email folder on more than one level in Outlook:
- Click on the View tab
- Click on View Settings
- Click on Sort
- Click the first listed field under “Sort items by” and select the field for the first sort level
- Click the radio button next to Ascending or Descending as appropriate
- Click the second box and select the second sort field and the sort order
- Continue as above for any further sort levels
- Click on OK and then on OK again to close the dialogue boxes
The sort settings for the folder will be remembered such that each time this email folder is opened the contents will be sorted in the same way until you instruct otherwise.
Sorting files on more than one level in File Explorer
This one’s easy – but not at all self-evident. The first sort level is achieved by just clicking on the column name. You will then see a “v” or inverted “v” next to the heading on which the sort applies. If you want to reverse the sort order, just click on the column name again. To create a second sort level, depress the shift key and (while the shift key is still depressed) click on the second column heading. There is no visible indicator on the column headings to show that you are sorting on more than one column but it does work (see the illustration below).
PS: When I use the word “Outlook”, I mean the email program that is part of the Microsoft Office suite of programs – not any other email facility of Microsoft to which they have confusingly applied this name.