The data that you have filtered or sorted in a range of cells or table can be reapplied a filter or sort to get up-to-date results. You can determine if a filter is applied or not by noting the icon in the column heading.
- If you see a drop-down arrow button in the column heading, means that the filter is enabled but not applied yet.
Note: When you hover over the column heading with filtering enabled but not applied, you will see a screen tip display "(Show All)".
- If the column heading displays the filter button , means that filtering is applied.
Note: When you hover over the column heading that is applied a filter, you will see a screen tip display the filter applied to that column, such as "Does not equal "Lavy" or Less than 2000".
Once you reapply a filter or sort data, you get the different results because of the following reasons:
- Data has been added, modified, or deleted to the range of cells or table column.
- You use a filter that is the dynamic date and time filter, such as Today, This Week, Year to date, etc.
- The formula returned values that have changed and the worksheet has been recalculated.
Note: When you search filtered data by using the Find dialog box, only the displayed data is searched. The data that is not displayed is not search. If you want to search all the data, you need to clear all filters.
To reapply a filter or sort, on the Home tab, in the Editing group, click Sort & Filter, and then click Reapply.
You can also use shortcut key by pressing Ctrl +Alt+ L.
Note: When you filter or sort data in a table, the criteria of filtering or sorting are saved within the workbook so that you can reapply both the filter and sort each time when you open the workbook. However, only filter criteria in range of cells are saved with the workbook, not sort criteria. If you want to save sort criteria so that you can regularly reapply a sort when you open the workbook, you can use a table instead. It is important for multicolumn sorts or for sorts with complex criteria that you take long time to create them.
In point I of filtering and sorting data lesson, you learn how to use the Filter command but you don't know how clear the filter. In this lesson, we will introduce you how to clear a filter for a column and clear all filters in a worksheet.
To clear a filter for a multicolumn rage of cells or table, click Filter button on the heading, and then click Clear Filter Form <Column Name> on the AutoFilter menu.
To clear all filters in a worksheet, on the Home tab, in the Editing group, click Sort & Filter, and then click Clear.
This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages: