Lesson 19


Filtering a Table; Practice Exercise 17

Practice Exercise 17 – Filtering a Table

STEP 1: Let’s filter some of our results. We only want to see 4 bedroom listings.

STEP 2: Select the Bedroom filter button. On the drop-down menu, uncheck the “Select All” checkbox. Check the “4” box. Select the OK button at the bottom of the menu.(FIGURE 1).

Figure 1

STEP 3: We still have the sorting action from our previous sort, but now it is only for 4 bedroom listings.
Notice that the Bedroom filter button icon has changed from its default downward pointing arrow to the filter funnel icon ​(FIGURE 2).

Figure 2

STEP 4: Unlike a sort, which can only be removed by the Undo button, a filter can be removed.
Select the filter button for the Bedrooms column. Select “Clear Filter from Bedrooms” choice on the drop-down menu (FIGURE 3).

Figure 3


Back to: Intermediate Excel 2016 > Module 2 – Intermediate Excel 2016

Leave a Reply