Practice Exercise 15: Perform sorting on a Table using filter buttons
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.The resulting table is shown in FIGURE 5.
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.
Notice that the Header Row, Banded Rows, and Filter Button boxes have been checked. Leave them as is.The resulting table is shown in FIGURE 5.
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 4
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. |
FIGURE 6
|
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). STEP 8: Select the filter button for the Location column. On the drop-down menu select “Sort A to Z” choice (FIGURE 8). STEP 9: Select the filter button for the Salesperson column. On the drop-down menu select “Sort A to Z” choice (FIGURE 9). |
FIGURE 7
FIGURE 8
FIGURE 9
|
This is the end of this section. To continue, go to Module 2 Section 2.10 Sorting a Table – Using a Custom Sort to Sort a Table; Practice Exercise 16