When you are using a Pivot Table in Excel and want to know what data makes up a certain value, all you have to do is double click on that cell.

This will open up a brand new Sheet with all the rows of data that make up that value.

NB. This is an extraction of your data source, so if you edit the information and Refresh your Pivot Table then nothing will happen.  Any changes need to be made in your main data source.

If you want to get rid of this sample data, all you have to do is press CTRL+Z and press DELETE in the pop up pox.

So go ahead and double click on any values (including SubTotals and GrandTotals) within your Pivot Table to view the data that makes up your selected value.



STEP 1: Double click on any value cell within the Pivot Table

This opens up a new sheet with the data that makes up the selected cell.


Drill Down to Audit





If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest


Share on Facebook


Tweet about this on Twitter


Share on LinkedIn


Share on Google+


Related Posts

Sort Field List In a Pivot Table from A to Z Do you ever get in a situation where your Pivot Table Field List has over 20 fields and you spend heaps of time trying to locate one within the Field List? Well you can save time by sorting the Pivot Table Field List in alphabetical order! To do this you need to Right Click...
Format Error Values in a Pivot Table Whenever you do a calculation in an Excel Pivot Table you may get an error value like a #DIV/0! This looks ugly when you are presenting important information.  Luckily you can override this with a custom value or text. To activate this you need to Right Click in any Value i...
Sorting a Pivot Table There are a few ways that you can Sort a Pivot Table.  You can Sort the Row/Column Labels as well as Values within a Pivot Table.  Below I show you three quick ways... DOWNLOAD WORKBOOK Helpful Resource:  
Show The Difference From Previous Months With Exce... Excel Pivot Tables have heaps of calculations under the SHOW VALUES AS option and one that gets the most use is the DIFFERENCE FROM calculation. You can show the values as the Difference From previous months, years, day etc.  This is just great when your boss asks you how you ...