Excel 2016 Tips and Tricks

Lesson 2 – Working with Tables

Excel 2016

Sorting data by multiple levels

NOTE To reverse a sort, you can use the Undo feature immediately following the sort operation.



P ROCEDURES

1. Select any cell in the table. 2. Select the Data tab.

3. Select

in the Sort & Filter group.

4. Select the Column Sort by list. 5. Select the name of the column you want to use for the first level of sorting. 6. Select the Sort On list. 7. Select the desired option. 8. Select the Order list. 9. Select the desired option. . 11. Select the Column Then by list. 12. Select the name of the column you want to use for the second level of sorting. 10. Select

Page 44

OFFICEPRO, Inc.