Clear a filter in Excel

After filtering has been done, you might want to change or do away with the filtering.

Clearing can be done by following the steps below. Let’s Begin.

  • Click the drop-down menu for the filter you wish to clear. In the example below, we will clear the filter in column D
Clear a filter
  • The filter menu will show up.
  • Select “clear filter” from the filter menu.
Clear a filter
  • The filter will be removed from the column. The former hidden information will be visible.

Leave a Reply

WEEKNUM Function

The WEEKNUM Function in Excel will return the week number for a specific date. This function will return an integer

Read More »
Scroll to Top