Situatie
You need to apply filters on different columns in excel.
Solutie
Pasi de urmat
-
Select any cell within the range.
- Select Data > Filter.
- Select the column header arrow
. - Select Text Filters or Number Filters, and then select a comparison, like Between.
- Enter the filter criteria and select OK.
Filter data in a table
When you Create and format tables, filter controls are automatically added to the table headers.
- Select the column header arrow
for the column you want to filter. - Uncheck (Select All) and select the boxes you want to show.
- Click OK.
The column header arrow changes to a 
Filter icon. Select this icon to change or clear the filter.
Leave A Comment?