Office 2010 Tips - Faster search in Excel Tables and PivotTables

Faster search in Excel Tables and PivotTables

Microsoft Excel 2010 gives you new and faster searches in Tables, PivotTables, and AutoFilters with a streamlined way to look through large amounts of data and create new filters. So even if you have a report with more than 1 million items you need to search, Excel 2010 has a fast solution with PivotTable Search.

Step by Step: To search by Value 1. Select your PivotTable. 2. Click the down arrow at the right end of the row label in the row you want to search. 3. In the Search text box, enter the value for which you want to search. This will bring that value forward; then click the checkbox for that value. For example, your PivotTable shows revenue for all your stores, but you only want to look at the revenue from the Redmond Way store. 4. To filter your PivotTable report to show just the Redmond Way store, click OK to display the result. To Create a Custom AutoFilter 1. Select your PivotTable. 2. Click the down arrow at the right end of the row label in the row you want to search. 3. Click Label Filters, and then click on the criteria. For example, if you want to analyze the difference in revenue between stores that are on streets versus those that are on avenues, click Contains. 4. In the Custom AutoFilter dialog box, next to the filter criteria list, enter a value, such as “Street.” 5. Click OK to display only the stores you want to see.