Let’s take a look.
Here we have a table that contains 300 property listings.
Let’s use Excel’s filter tools to explore this information.
First, we need to enable filter mode.
Select any cell in the table, then tap the Filter button on the Data tab of the ribbon.
you’re free to also use the keyboard shortcut Control-Shift-L to toggle filter mode on and off.
Let’s start by filtering to show only properties below $500,000.
First, grab the arrow in the Price column to display filter options.
Then, choose Number Filters and select “Less Than…”.
Enter 500000 in the dialog and click OK to apply.
The table is now filtered, and the status bar tells us how many records are displayed.
Now let’s filter the list to show only single family homes.
Click Select All to deselect all types, then click Single family.
There are now 135 properties visible.
Let’s further restrict listings to show only properties with 4 bedrooms or more with at least 2 baths.
Both of these filters use Greater Than Or Equal To, in the Number filters menu.
Finally, let’s filter to show only properties listed in 2013.
The Date Listed column holds a date, so we see a Date Filters item in the filter tweaks.
The Date Filters menu contains a huge list of options for relative time periods.
But we can also use the Date tree below to select all dates in 2013.
Now, based on the five filters we’ve set, there are 11 out of 300 properties displayed.
you might hover over any filter button to see a description of the applied filter.
you’re free to clear filters one at a time by selecting Clear Filter in each column.
Let’s undo and look at one more way to clear all filters at the same time.
This clears all filters and disables filter mode altogether.
