Tip Printed from ExcelTip.com

---

Getting Drill-Down Details


To get full drill-down details:

In the PivotTable report, select a cell in the Data area for which you want to get drill-down details and double-click. A new sheet is automatically inserted with an itemized data List showing all rows included in the selected cell.

Example: Double-click cell B7, see screenshot.