Pivot Table Issues

How to Show Details for Excel PivotTable Values

Maira MehtabMaira Mehtab Nov 14, 2026 868 views

Question details

The user wants to know whether Excel removed Show Details from the PivotTable right-click menu and how to extract the underlying records.

How to Show Details for Excel PivotTable Values
Product
Microsoft Excel PivotTables
Device & OS
not provided
Scenario
The user wants to inspect the records behind a summarized PivotTable value.
Observed behavior
Show Details may be absent from the right-click menu, but double-clicking a value can still open its underlying records.
Before you start

Open the workbook containing the PivotTable and identify a numeric cell in its Values area. If you cannot extract details, check whether the PivotTable's Show Details setting is enabled.

Solution 1Recommended

Double-click a PivotTable value to extract its records

Use this method when Show Details is missing from the right-click menu.

1
Find a summarized value

Click a numeric cell in the PivotTable Values area, such as a sum or count.

2
Open the details

Double-click the value. If a Show Details dialog appears, follow its prompts.

3
Review the new worksheet

Open the worksheet Excel creates to inspect the underlying records for the selected value.

Double-click a PivotTable value to extract its records
Availability can vary: The right-click command and the available details can vary by Excel version and data source. Double-clicking a value does not necessarily restore the missing menu command.
Free Microsoft Office alternative

Explore PivotTable data with WPS Spreadsheets

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel workbooks in WPS Spreadsheets for an easier transition, though it does not restore commands in Microsoft Excel.

Work with spreadsheet summaries and PivotTables in WPS SpreadsheetsCompatible with Microsoft Excel formats, including XLSX and XLSFamiliar interface for users moving from Microsoft OfficeFree and lightweight office suite
QA img-9

Frequently Asked Questions

Was Show Details removed from Excel PivotTables?

The command may be missing from the right-click menu in some Excel versions. You can still try double-clicking a numeric cell in the PivotTable Values area to extract its details.

Where do the extracted records appear?

When drill-down succeeds, Excel creates a new worksheet containing the records behind the selected PivotTable value.

Why doesn't double-clicking a value show the records?

Right-click the PivotTable, open PivotTable Options, and check Enable show details on the Data tab. The data source may also restrict the details available.

Can I ask Microsoft to restore the right-click command?

Yes. In Excel, use File > Feedback or Help > Feedback, depending on your version, to request the return of Show Details to the context menu.