Excel 2016 Tips and Tricks

Excel 2016

Lesson 2 – Working with Tables

13. Select the Sort On list. 14. Select the desired option. 15. Select the Order list. 16. Select the desired option. 17. Add additional levels of sorting as required. 18. Select OK .



S TEP - BY -S TEP Sorting data by multiple levels.

Steps

Practice Data

1. Select any cell in the table. The cell is selected.

Click cell G8

2. Select the Data tab.

Click Data

The Data tab is displayed.

3. Select the Sort button in the Sort & Filter group. The Sort dialog box opens. 4. Select the Column Sort by list. A list of table column names is displayed. 5. Select the name of the column you want to use for the first level of sorting. The column name appears in the Sort by box.

Click

Click Sort by

Click Region

6. Select the Sort On list.

Click Sort On

A list of options is displayed.

7. Select the desired option.

Click Values , if necessary

The selected option appears in the Sort On box.

8. Select the Order list.

Click Order

A list of options is displayed.

9. Select the desired option.

Click A to Z , if necessary

The selected option appears in the Order box.

10. Select the Add Level button.

Click

A new row of options is displayed.

OFFICEPRO, Inc.

Page 45