Display The Details Behind Your Pivot Table Data With One Click


Ever need to drill down into your Pivot Table to look at the details behind your summary calculations?  Simple stuff with the double click of a mouse and Excel will display all of the details behind the summary on a brand new worksheet.

Let’s  look at an example.

The Sales of Widget_A have outsold Year to date in 2013 than any other type of Widget.  Let’s take a closer look at those sales.  We can can double click on cell B4 and drill down to get those details.  Easy as that!

 

 

 

 

 

 

 

 

 

 

That’s it.  You can easily see the data behind the sales of Widget_A

More Excel Tips

1. Follow Pivot Table Week at How To Excel At Excel Right HERE

2. Calculate Running Totals in Pivot Tables

3. Show Zero values in a Pivot Table

Barbara

Barbara is an experienced data analyst with over 20 years of experience. Author of the How To Excel At Excel Top 50 Excel tips Ebook, YouTuber and Excel Blogger.

Recent Posts