Lesson 17

Preview

Sorting a Table – Using Filter Buttons to Sort a Table – Practice Exercise 15

Practice Exercise 15: Perform sorting on a Table using filter buttons

STEP 1: Still using the data file, FIRST RANGE TO TABLE EXERCISE. Select TABLE SORT tab. Make cell A1 the active cell (FIGURE 1).

STEP 2: The first step in creating a table is selecting the Table option. Go up to the Ribbon and select the Insert tab. In the Tables section, select Table with mouse (FIGURE 2).

STEP 3: The Create Table dialog box range should be $A$1:$G$276. Check the box, “My table has headers” (FIGURE 3).
Click the OK button

STEP 4: From the palette of Table Style choices (FIGURE 4) select – Table Style Light 20.
Notice that the Header Row, Banded Rows, and Filter Button boxes have been checked. Leave them as is

Figure 4

The resulting table is shown in FIGURE 5 below.
Tip: For future use – if you don’t want the downward pointing filter buttons on each header field, banded rows, or header row, uncheck the appropriate box.

Figure 5

STEP 5: Highlight the entire table using mouse or CTRL + A keys.
Select the filter button (down arrow) on the Listing Date header cell.

STEP 6: Select the choice “Sort Oldest to Newest” on the drop-down menu. Notice the dates listed are shown oldest to newest (FIGURE 6).

Select the Undo button to undo this sort.

STEP 7: Now we’ll do a 3-column sort. Our sort priority is: 1. Salesperson, 2. Location, 3. Listed Price.
Our first choice, Salesperson, is actually chosen last; last choice for the sort is selected first. This is due to the way filter buttons work.
Select the filter button for the Listed Price column. On the drop-down menu select “Sort Smallest to Largest” choice (FIGURE 7).