O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Displaying the Details Behind a Data Value

By double-clicking a data value, you "drill down" to the details behind the value. Excel copies the detail figures to a new workbook page.

Figure 30-19 shows an example of this process. When you double-click the 2001 Total cell for CatalogNo 23524 (cell G9 in Figure 30-2), Excel responds by listing all the entries from the data source that contributed to that PivotTable value.

Double-clicking a value causes Excel to display the entries summarized by that value.

Figure 30-19. Double-clicking a value causes Excel to display the entries summarized by that value.

You can turn off this capability by opening the PivotTable Options dialog box (choose PivotTable, Table Options) and clearing the Enable ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required