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

Randomly Sort Data in Excel

Learn to randomly sort data in Excel by using this simple trick. The RAND Function can be used to randomly sort a data set by applying a numerical number.

Read More »

MINUTE Function

The MINUTE function in Excel returns the minute component of a specified time as a number between 0-59. Syntax: =MINUTE(serial_number)

Read More »
Scroll to Top