Excel Power Pivot & Power Query For Dummies
Book image
Explore Book Buy On Amazon

Here's a neat trick. Right-click a cell in an Excel pivot table and then choose the Show Details command from the shortcut menu. Excel adds a worksheet to the open workbook and creates an Excel table that summarizes individual records that together explain that cell's value.

For example, if you right-click cell C8 in the workbook shown here and choose the Show Details command from the shortcut menu, Excel creates a new table.

Group data in a pivot table.
Group data in a pivot table.

The following figure shows all the information that gets totaled and then presented in cell C8.

A detail list shows where pivot table cell data comes from.
A detail list shows where pivot table cell data comes from.

You can also show the detail that explains some value in a pivot table by double-clicking the cell holding the value.

About This Article

This article is from the book:

About the book author:

Michael Alexander is a Microsoft certified application developer and author of several books on advanced business analysis with Microsoft Access and Microsoft Excel. He has been named a Microsoft MVP for his ongoing contributions to the Excel community.

This article can be found in the category: