Saving Filtering Criteria in Excel 2007

To save filtering criteria, use Custom Views: 1. Filter a List. 2. Select Page layout -> Custom Views (in Sheet Options Group) -> Add. 3. I...

Filtering by More Than Two Criteria in Excel 2007

To filter a List using more than one criteria, use the Advanced Filter: 1. Insert three new rows above the List. 2. Copy the heading row List, and...

Coloring Visible Rows in Filtered List in Excel 2007

To color filtered List according to a criteria: 1. Filter the List according to any criteria. 2. Select a cell in filtered area, press Ctrl+Shift+...

Summing the Visible Filtered List Values in Excel 2007

To total the values in the visible filtered rows, use the SUBTOTAL function: 1. Filter the List by selecting any criteria. 2. Select a cell in the...

Filtering by Data Type in Excel 2007

When filtering the List, Filter recognizes the type of data in each field: such as text, date or a numeric number. The sub-menu filters is changed...

Sort Ascending/Descending While Using Filter in Excel 2007

To sort a List: This option enables to sort from the Filter dropdown list identical to the Sort A to Z/Sort Z to A or Sort by Color). ...

The Filter Ribbon in excel 2007

To add filters to a List: Select Home -> Sort & Filter (in Editing Group -> Filter. Or Select Data -> Filter (in Sort & Filter G...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube