{"id":1392,"date":"2015-06-16T12:40:27","date_gmt":"2015-06-16T10:40:27","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=1392"},"modified":"2024-02-06T15:45:36","modified_gmt":"2024-02-06T14:45:36","slug":"drill-down-to-audit-using-a-pivot-table-in-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/drill-down-to-audit-using-a-pivot-table-in-excel\/","title":{"rendered":"Drill Down To Audit Using a Pivot Table"},"content":{"rendered":"<p>When you are using a <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\" title=\"Pivot Table\" data-wpil-keyword-link=\"linked\">Pivot Table<\/a> in Excel and want to know what data makes up a certain value, all you have to do is double click on that cell.<\/p>\n<p>This will open up a brand new Sheet with all the rows of data that make up that value.<\/p>\n<p><em>NB. This is an extraction of your data source, so if you edit the information and Refresh your Pivot Table then nothing will happen.\u00a0 Any changes need to be made in your main data source.<\/em><\/p>\n<p>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.<\/p>\n<p>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.<\/p>\n<div class=\"after-post-box\">\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/CF5v3WEAHgI?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/06\/Drill-Down-to-Audit.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/06\/Drill-Down-to-Audit.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">Drill-Down-to-Audit.xlsx<\/span><\/a><\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong> <\/span>Double click on any value cell within the Pivot Table<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/06\/03-drill-down-to-audit-01.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Drill Down To Audit Using a Pivot Table\"  class=\"alignnone size-full wp-image-6697\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/06\/03-drill-down-to-audit-01.jpg\" alt=\"Drill Down To Audit Using a Pivot Table\" width=\"377\" height=\"199\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/06\/03-drill-down-to-audit-01.jpg 377w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/06\/03-drill-down-to-audit-01-300x158.jpg 300w\" sizes=\"(max-width: 377px) 100vw, 377px\" \/><\/a><\/p>\n<p>This opens up a new sheet with the data that makes up the selected cell.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/06\/03-drill-down-to-audit-02.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Drill Down To Audit Using a Pivot Table\"  class=\"alignnone size-full wp-image-6698\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/06\/03-drill-down-to-audit-02.jpg\" alt=\"Drill Down To Audit Using a Pivot Table\" width=\"503\" height=\"102\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/06\/03-drill-down-to-audit-02.jpg 503w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/06\/03-drill-down-to-audit-02-300x61.jpg 300w\" sizes=\"(max-width: 503px) 100vw, 503px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"text-decoration: underline;\"><span style=\"color: #0000ff; text-decoration: underline;\">HELPFUL RESOURCE:<\/span><\/span><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100.html\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1080 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/03\/728x90.gif\" alt=\"728x90\" width=\"728\" height=\"90\" title=\"\"><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":17545,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[17,4],"tags":[87,86],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/1392"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=1392"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/1392\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17545"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=1392"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=1392"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=1392"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}