Microsoft Excel 2007 tutorial: reapply a filter or sort dara


Reapply a filter and sort

IV. Reapply a filter and sort

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 Excel 2007 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)".

Excel 2007 screen tip of filtering not applied

- If the column heading displays the filter button Excel 2007 filtered 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".

Excel 2007 screen tip of filtered column

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.

Excel 2007 reapply filter and sort

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.

V. Clear a filter for a column

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.

Excel 2007 clear a filter for a column

VI. Clear all filters in a worksheet

To clear all filters in a worksheet, on the Home tab, in the Editing group, click Sort & Filter, and then click Clear.

Excel 2007 clear all filters in a worksheet

 


Comments

vihan comment

 vihan

excel is very powerfull application in computer, those are most commonly used in our life


2016-11-01
vihan comment

 vihan

excel is very powerfull application in computer, those are most commonly used in our life


2016-11-01




This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages:
C, C++, C#, Java, VB.NET, Python, VBA,PHP & Mysql, SQL, JSP, ASP.NET,HTML, CSS, JQuery, JavaScript and other applications such as MS Excel, MS Access, and MS Word. However, we don't guarantee all things of the web are accurate. If you find any error, please report it then we will take actions to correct it as soon as possible.