Filter is one of the most useful and powerful tools in Excel
- You keep visible only some rows
When you apply a criterion to a column, only the rows with this criterion are visible
- Data are not deleted
When a filter is applied to a criterion, the rest of the rows are not deleted. They are just hidden
How to visualize the filters?
You know that the filter is ON when you see arrows on the headers of your table.
Activate the Filter
- Select one of the cells of your table
- Activate the filter in the Data > Filter
- Now you see arrows in the header of your table
- You can also activate the filter with the shortcut Ctrl + Shift + L
Apply a filter for one criterion
Working with the filter is very easy. To select only the rows for the country Germany (DE), you must do the following steps
- Go to the header of the column where you want to apply the filter
- Click on the arrow
- Uncheck all items (Select All)
- Select only the item you want (in this case, Beverages)
- Only the rows with this criterion are visible. The other rows are simply hidden.
- You know when your table is filtered when the row numbers are colored in blue. As you can see, only the row numbers of the rows containing your criterion are visible.
Apply a filter on many columns
You can filter many columns. There is no limitation. For instance, we want to select the following values
- Male in column Gender
- DE and AT in column Country
- Beverages in the column Category
How many rows are filtered?
When you activate a filter, you can see how many rows are returned by looking at the bottom left in the status bar
If you use Excel 365 or Excel 2021, you can filter dynamically your data with the FILTER function
Removing filters is also important. You can remove them by clicking on this option