Reapply a filter and sort, or clear a filter

Once you have filtered or sorted data in a range of cells or table column, you can either reapply a filter or sort to get up-to-date results, or clear a filter to redisplay all of the data.What do you want to do?

Learn more about reapplying a filter and sort

Reapply a filter or sort

Clear a filter for a column

Clear all filters in a worksheet and redisplay all rows

Learn more about reapplying a filter and sort

To determine if a filter is applied, note the icon in the column heading:

• A drop-down arrow means that filtering is enabled but not applied.

  Tip When you hover over the heading of a column with filtering enabled but not applied, a screen tip displays "(Showing All)".

• A Filter button means that a filter is applied.

  Tip When you hover over the heading of a filtered column, a screen tip displays the filter applied to that column, such as "Equals a red cell color" or "Larger than 150".

When you reapply a filter or sort, different results appear for the following reasons:

• Data has been added, modified, or deleted to the range of cells or table column.
• The filter is a dynamic date and time filter, such as Today, This Week, or Year to Date.
• Values returned by a formula have changed and the worksheet has been recalculated.

Note When you use the Find dialog box to search filtered data, only the data that is displayed is searched; data that is not displayed is not searched. To search all the data, clear all filters.

Reapply a filter or sort

Note For a table, filter and sort criteria are saved with the workbook so that you can reapply both the filter and sort each time that you open the workbook. However, for a range of cells, only filter criteria are saved with a workbook, not sort criteria. If you want to save sort criteria so that you can periodically reapply a sort when you open a workbook, then it's a good idea to use a table. This is especially important for multicolumn sorts or for sorts that take a long time to create.

• To reapply a filter or sort, on the Home tab, in the Editing group, click Sort & Filter, and then click Reapply.

Clear a filter for a column

• To clear a filter for one column in a multicolumn range of cells or table, click the Filter button on the heading, and then click Clear Filter from <Column Name>.

Clear all filters in a worksheet and redisplay all rows

• On the Home tab, in the Editing group, click Sort & Filter, and then click Clear.