Sorting & Filtering Data in Excel 2007

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…]

Sorting Excel 2007 Data on Multiple Columns

If your Excel 2007 worksheet has become quite large, using the Sort dialog box to sort on multiple columns can make it easier to find the data you need. The Sort dialog box lets you tell Excel what column [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…]

Sorting Excel 2007 Data on a Single Column

You may find data in an Excel 2007 worksheet easier to view if it’s sorted on a particular column, in ascending or descending order. Excel sorts in the following pattern: numbers, spaces, special characters [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…]

Sign Up for RSS Feeds

Computers & Software
Great Gadget Giveaway -- Enter to Win!

Inside Dummies.com