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

If Function

The IF Function in excel is a logical test that can be run using specific conditions. This logical test returns

Read More »

YEARFRAC Function

The YEARFRAC function in Excel returns a decimal value that represents fractional years between two specified dates. Syntax: =YEARFRAC(start_date, end_date,

Read More »
Scroll to Top