Jun 16, 2014
Did you know that in Microsoft Word, you can sort your information up to 3 levels? This means that when all things are equal in the first column then it will do a second level sort on the second column you specify, and then when all things are equal in that column it will further sort by the third specified column. In the example below, I want to sort my lists by the 'Job Role' followed by the 'Name' and then by the 'Location.' If I did a single level sort then it would probably sort alphabetically by name. When you do a multi-level sort, for example, it allows you to group items and then sort alphabetically.How to sort by one level
- Select the list in question that you want to sort, and click the 'Sort' button in the 'Paragraph' group.
- In the first drop-down list, look to see if it says 'Field 1' or if it uses the headings (e.g. 'Name'). If it says 'Field 1' then click the radio button next to 'My list has' that says 'Header Row.' You should notice it now uses the column headings rather than 'Field 1.'
- Make sure to choose what you want it sorted by for (e.g. Name) and then click OK.
- It should look like the list below now sorted alphabetically by Name.
How to sort by two levels
- Repeat the steps 1-3 above but instead, change the first drop-down field to sort by 'Job Role.'
- In the second drop-down field, select 'Name' and then click OK.
- It should now look like this:
How to sort by three levels
- Again, follow the same steps 1-3 as above, but leave the first drop-down to sort by 'Job Role.'
- Change the second drop-down field to 'Location.'
- Change the third drop-down field to 'Name' and then click OK.
- It should now look like this:
How do your Excel skills stack up?
Test NowNext up:
- Taking the shortcuts in Windows 8
- Life has many, many stations. Having trouble getting to your next station?
- Data Quality in SQL Server 2014 for dummies (Part 1)
- Automatically reach your deadlines with scheduled tasks in Microsoft Project
- Manage your administration with ADAC and PowerShell
- Customise the weather forecast in Outlook 2013
- Data Quality in SQL Server 2014 for dummies (Part 2)
- Protecting content in Microsoft Word with 'Restrict Editing'
- How to populate tables in Excel VBA
- Monitoring communication sessions in Lync Server 2013
Previously
- Spring clean your PC with Windows ‘Disk Cleanup’
- Pinpoint your 3D chart's data points with drop lines in Excel
- The seven keys to develop your personal effectiveness
- 4 tips to make you a Windows 8.1 pro
- Sorting made easy with custom lists in Excel
- TechEd 2014 – Australia’s largest Microsoft IT exhibition is evolving!
- Communicating clearly to save time and money
- Reliability Monitor in Windows 8
- Borders and shading in Microsoft Word 2010
- Implementing security in SQL Server 2014