In Excel, you can apply filters in several ways to display specific data while hiding the rest. Here are the different methods:
1. Using the Filter Button (AutoFilter)
Steps :
- Select the header row of your dataset.
- Go to the Data tab.
- Click Filter (a small drop-down arrow appears on each column header).
- Click the drop-down arrow and:
- Check/uncheck values to filter specific ones.
- Use Text Filters, Number Filters, or Date Filters for advanced filtering.
2. Using Advanced Filter
Steps :
- Go to the Data tab and click Advanced (next to the Filter button).
- Choose:
- Filter the list, in-place (to filter data directly).
- Copy to another location (to extract filtered data elsewhere).
- Set the criteria range (a separate area with conditions).
- Click OK to apply.
3. Using Slicers (For Tables and PivotTables)
Steps :
- Convert your data into a table (Ctrl + T).
- Click anywhere in the table, go to the Table Design tab.
- Click Insert Slicer and choose the column you want to filter.
- Click on the slicer buttons to filter data visually.
4. Using Search in the Filter Dropdown
Steps :
- Click the Filter drop-down arrow in a column.
- Use the search box to type the value you want.
- Check the matching results and click OK.
5. Using Custom Filters
You can filter based on specific conditions like:
- Text Filters → "Contains," "Begins with," "Ends with."
- Number Filters → "Greater than," "Between," "Top 10."
- Date Filters → "Before," "After," "Last month."
Steps :
- Click the filter drop-down in the column.
- Select Number, Text, or Date Filters.
- Set your condition and apply.
