Excel: set filter
Setting a filter in Excel makes data sheets with many entries much clearer. And this is how it works.
Set a filter in Excel
To set a filter:
- Go to the "Start" tab.
- The "Sort and Filter" function is located on the far right of the Excel ribbon.
- After clicking on it, select "Filter" from the drop-down menu.
- Now each column heading should have turned into a dropdown list.
- By clicking on the arrow of a heading, you can select what you want to filter in the opened menu - simply set or remove the checkmarks in front of the respective entry. Alternatively, you can sort the values in the respective column in ascending or descending order.
- If you only want to filter one column, select it first and then go to "Sort and Filter" as described in step 3.
The instructions refer to Microsoft Excel 2013.