A Filter in Excel to put
Proceed as follows to set a Filter:
- Go to the Tab "Start".
- The far right of the Excel ribbon, the function is a "sorting and Filtering".
- After clicking on it, select in the drop-down menu "Filters".
- Now each column header into a drop down should have a list of transforms.
- By clicking on the arrow of a Heading, you can select in the drop - down menu that you want to filter or remove the checkmark 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 a column, mark it first and then go only as described in step 3 to the "sort and Filter".
Table after the Filter
The guide applies to Microsoft Excel 2013.
