Filtering

View:

Sorted by:

Filtering and Sorting an Excel 2007 Pivot Table

You can filter and sort the data in an Excel 2007 pivot table to display a subset of data arranged how you want to view it. Excel automatically adds drop-down filter arrows to the Report Filter field as [more…]

Filtering an Excel 2007 Pivot Chart

Just as you can filter an Excel 2007 pivot table to display a subset of data, you also can use the PivotChart Filter pane to filter a pivot chart so that it shows just the information you want it to show [more…]

Using Advanced Filtering in Excel 2007

You can specify complex filtering criteria in Excel 2007 and designate a specific area of your worksheet to manage your criteria selections when filtering table data by using advanced filtering methods [more…]

Creating Custom AutoFilters for Numbers in Excel 2007

Use the Custom AutoFilter dialog box in Excel 2007 to locate records that either match all criteria or meet one or the other criteria. You can use this method when you want to filter data based on a range [more…]

Filtering by Date in an Excel 2007 Table

If your Excel 2007 table includes columns with dates or times, you can filter the table to display a subset of the data with the dates or times you specify. The rows that do not match the criteria you [more…]

Filtering by Color in an Excel 2007 Table

If you’ve applied color to fonts or cells in an Excel 2007 table, you can filter the table to display a subset of the data with the colors you specify. The rows that do not match the criteria you specify [more…]

Filtering Records in an Excel 2007 Table with AutoFilter

Use the AutoFilter feature in Excel 2007 to hide everything in a table except the records you want to view. Filtering displays a subset of a table, providing you with an easy way to break down your data [more…]

Filtering Numbers in an Excel 2007 Table

If you’re working with a large table of data in Excel 2007, you can apply number filters to columns that contain values to temporarily hide unwanted records. Excel provides several options for filtering [more…]

Creating Custom AutoFilters for Text in Excel 2007

Use the Custom AutoFilter dialog box in Excel 2007 to locate records that either match all criteria or meet one or the other criteria. You can use this method for more flexibility when filtering text [more…]