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