60. Clearing filters
Clearing Filters
**Clearing Filters** in Excel allows you to reset all applied filters, displaying the full dataset again. This is helpful when you want to start a new analysis or ensure no rows are hidden due to filtering.
Steps to Clear Filters
- Step 1: Go to the Data tab.
- Step 2: Click on Clear under the Sort & Filter group.
- Step 3: Excel removes all filters, displaying the entire dataset.
Interactive Example: Clear Filters
# | Department | Age |
---|---|---|
1 | Finance | 25 |
2 | HR | 35 |
3 | IT | 42 |
4 | Finance | 29 |
Use the dropdowns to apply filters, then click "Clear Filters" to reset and display all rows.
Comments
Post a Comment