{"id":1541,"date":"2015-08-07T16:52:14","date_gmt":"2015-08-07T14:52:14","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=1541"},"modified":"2024-02-06T15:45:42","modified_gmt":"2024-02-06T14:45:42","slug":"classic-pivot-table-layout-view-in-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/classic-pivot-table-layout-view-in-excel\/","title":{"rendered":"Classic Pivot Table Layout View"},"content":{"rendered":"<p>For all of you old schoolers out there who used to use the drag and drop <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> option in Excel 2003 or prior, well you still have that option in Excel 2010 and onwards.<\/p>\n<p>To activate this option you need to Right Click in your Pivot Table and choose Pivot Table Options.<\/p>\n<p>Then under the Display tab you need to &#8220;check&#8221; the Classic Pivot Table Layout box.\u00a0 This will enable you to drag your Fields from the Field List straight into the Pivot Table, just like the good ol&#8217; days!<br \/>\n<iframe src=\"https:\/\/www.youtube.com\/embed\/jgpjy58WOlc?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><\/p>\n<p><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><br \/>\n<span style=\"text-decoration: underline; color: #0000ff;\"><a class=\"IRPP_minimalist icon-download\" style=\"color: #0000ff; text-decoration: underline;\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Classic-Pivot-Table-Layout.xlsx\" target=\"_blank\"><span class=\"ctaText px-3 text-capitalize\">Download workbook<\/span><span class=\"postTitle px-3\">Classic-Pivot-Table-Layout.xlsx<\/span><\/a><\/span><\/p>\n<p>This is our starting Pivot Table showing our sales totals:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Classic Pivot Table Layout View\"  class=\"alignnone size-full wp-image-23377\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Classic-Pivot-Table-Layout-View-01.jpg\" alt=\"Classic Pivot Table Layout View\" width=\"475\" height=\"184\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Classic-Pivot-Table-Layout-View-01.jpg 475w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Classic-Pivot-Table-Layout-View-01-300x116.jpg 300w\" sizes=\"(max-width: 475px) 100vw, 475px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1: <\/strong><\/span><strong>Right click<\/strong> in the Pivot Table and select\u00a0<strong>PivotTable Options<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Classic Pivot Table Layout View\"  class=\"alignnone size-full wp-image-23378\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Classic-Pivot-Table-Layout-View-02.jpg\" alt=\"Classic Pivot Table Layout View\" width=\"255\" height=\"369\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Classic-Pivot-Table-Layout-View-02.jpg 255w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Classic-Pivot-Table-Layout-View-02-207x300.jpg 207w\" sizes=\"(max-width: 255px) 100vw, 255px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2: <\/strong><\/span>Go to <em><strong>Display &gt; Classic PivotTable Layout\u00a0<\/strong><\/em>and check that option<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Classic Pivot Table Layout View\"  class=\"alignnone size-full wp-image-23379\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Classic-Pivot-Table-Layout-View-03.jpg\" alt=\"Classic Pivot Table Layout View\" width=\"457\" height=\"477\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Classic-Pivot-Table-Layout-View-03.jpg 457w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Classic-Pivot-Table-Layout-View-03-287x300.jpg 287w\" sizes=\"(max-width: 457px) 100vw, 457px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3: <\/strong><\/span>Let us have some fun! Now you can drag fields into the Pivot Table<\/p>\n<p>Drag the <strong>Year<\/strong> away to remove it from the Pivot Table<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Classic Pivot Table Layout View\"  class=\"alignnone size-full wp-image-23380\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Classic-Pivot-Table-Layout-View-04.jpg\" alt=\"Classic Pivot Table Layout View\" width=\"782\" height=\"502\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Classic-Pivot-Table-Layout-View-04.jpg 782w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Classic-Pivot-Table-Layout-View-04-300x193.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Classic-Pivot-Table-Layout-View-04-768x493.jpg 768w\" sizes=\"(max-width: 782px) 100vw, 782px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 4: <\/strong><\/span>You can now drag the <strong>Customer<\/strong> field to your Pivot Table<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Classic Pivot Table Layout View\"  class=\"alignnone size-full wp-image-23381\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Classic-Pivot-Table-Layout-View-05.jpg\" alt=\"Classic Pivot Table Layout View\" width=\"603\" height=\"507\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Classic-Pivot-Table-Layout-View-05.jpg 603w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Classic-Pivot-Table-Layout-View-05-300x252.jpg 300w\" sizes=\"(max-width: 603px) 100vw, 603px\" \/><\/p>\n<p>You have now customized your Pivot Table the <strong>good old Classic way<\/strong>!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Classic Pivot Table Layout View\"  class=\"alignnone size-full wp-image-23382\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Classic-Pivot-Table-Layout-View-06.jpg\" alt=\"Classic Pivot Table Layout View\" width=\"1020\" height=\"278\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Classic-Pivot-Table-Layout-View-06.jpg 1020w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Classic-Pivot-Table-Layout-View-06-300x82.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Classic-Pivot-Table-Layout-View-06-768x209.jpg 768w\" sizes=\"(max-width: 1020px) 100vw, 1020px\" \/><\/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-5.html\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1538 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/728x90.gif\" alt=\"728x90\" width=\"728\" height=\"90\" title=\"\"><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>For all of you old schoolers out there who used to use the drag and drop Pivot Table option in Excel 2003 or prior, well you still have that option in Excel 2010 and onwards. To activate this option you need to Right Click in your Pivot Table and choose Pivot Table Options. Then under [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":17466,"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\/1541"}],"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=1541"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/1541\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17466"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=1541"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=1541"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=1541"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}