{"id":2416,"date":"2021-01-17T15:34:55","date_gmt":"2021-01-17T14:34:55","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=2416"},"modified":"2024-02-06T15:48:39","modified_gmt":"2024-02-06T14:48:39","slug":"insert-blank-rows-in-a-pivot-table-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/insert-blank-rows-in-a-pivot-table-excel\/","title":{"rendered":"Insert Blank Rows In a Pivot Table"},"content":{"rendered":"<p><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> reports are shown\u00a0in a Compact Layout format as a default and if you have <strong>two or more Items in the Row Labels<\/strong> (e.g.Month &amp; Customer), then the <strong>Pivot Table report can look very clunky<\/strong>&#8230;<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/clunky-pivot-table-report.png\" rel=\"attachment wp-att-2417\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Insert Blank Rows In a Pivot Table\"  class=\"alignnone size-full wp-image-2417\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/clunky-pivot-table-report.png\" alt=\"Insert Blank Rows In a Pivot Table\" width=\"441\" height=\"337\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/clunky-pivot-table-report.png 441w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/clunky-pivot-table-report-300x229.png 300w\" sizes=\"(max-width: 441px) 100vw, 441px\" \/><\/a><\/p>\n\n<p>There is a cool little trick that most Excel users do not know about that <strong>adds a blank row after each item, making the Pivot Table report look more appealing<\/strong>.<\/p>\n<h4>Here is how to insert a row in Pivot Table!<\/h4>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/Rd4wjvTCXmA?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><\/p>\n<p>Follow a step-by-step tutorial on how to insert row in pivot table and download this workbook to move along with us:<\/p>\n<p><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\/2016\/02\/Insert-Blank-Lines.xlsx\" rel=\"\" target=\"_blank\"><span class=\"ctaText px-3 text-capitalize\"><strong>download excel workbook<\/strong><\/span><span class=\"postTitle px-3\">Insert-Blank-Lines.xlsx<\/span><\/a><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1<\/strong><\/span>: Click any cell in the Pivot Table<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/Screenshot-88.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Insert Blank Rows In a Pivot Table\"  class=\"alignnone size-full wp-image-22492\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/Screenshot-88.png\" alt=\"Insert Blank Rows In a Pivot Table\" width=\"576\" height=\"472\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/Screenshot-88.png 576w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/Screenshot-88-300x246.png 300w\" sizes=\"(max-width: 576px) 100vw, 576px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span> Go to<strong><em>\u00a0Design &gt; Blank Rows<\/em><\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/Screenshot-89.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Insert Blank Rows In a Pivot Table\"  class=\"alignnone size-full wp-image-22493\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/Screenshot-89.png\" alt=\"Insert Blank Rows In a Pivot Table\" width=\"1032\" height=\"129\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/Screenshot-89.png 1032w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/Screenshot-89-300x38.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/Screenshot-89-1024x128.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/Screenshot-89-768x96.png 768w\" sizes=\"(max-width: 1032px) 100vw, 1032px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 3:<\/span> <\/strong>You will need to click on the Blank Rows button and select <em><strong>Insert Blank Line After Each Item<\/strong><\/em><\/p>\n<p><em>NB:\u00a0For this to work you will need at least two Pivot Table Items in the Rows Labels<\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/insert-blank-line-1.png\" rel=\"attachment wp-att-2419\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Insert Blank Rows In a Pivot Table\"  class=\"alignnone size-full wp-image-2419\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/insert-blank-line-1.png\" alt=\"Insert Blank Rows In a Pivot Table\" width=\"271\" height=\"126\" \/><\/a><\/p>\n<p>You then get the following Pivot Table report:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/insert-blank-rows-pivot-table-1.png\" rel=\"attachment wp-att-2421\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Insert Blank Rows In a Pivot Table\"  class=\"alignnone wp-image-2421 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/insert-blank-rows-pivot-table-1.png\" alt=\"Insert Blank Rows In a Pivot Table\" width=\"558\" height=\"549\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/insert-blank-rows-pivot-table-1.png 558w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/insert-blank-rows-pivot-table-1-300x295.png 300w\" sizes=\"(max-width: 558px) 100vw, 558px\" \/><\/a><\/p>\n<p>This tutorial shows you how to insert rows in pivot table and will make the Pivot Table look clean and more appealing.<\/p>\n<p>You can easily remove this blank row from Pivot Table as well!<\/p>\n<p><span style=\"color: #ff0000;\"><strong>METHOD 1<\/strong><\/span>: Simply press CTRL +\u00a0 Z if you have recently inserted a blank row.<\/p>\n<p><span style=\"color: #ff0000;\"><strong>METHOD 2:<\/strong> <\/span>Go to <strong>Design<\/strong> &gt; <strong>Blank Row dropdown<\/strong> &gt; Select <em><strong>Remove Blank Line After Each Item.<\/strong><\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/Screenshot-90.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Insert Blank Rows In a Pivot Table\"  class=\"alignnone size-full wp-image-22494\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/Screenshot-90.png\" alt=\"Insert Blank Rows In a Pivot Table\" width=\"1017\" height=\"208\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/Screenshot-90.png 1017w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/Screenshot-90-300x61.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/Screenshot-90-768x157.png 768w\" sizes=\"(max-width: 1017px) 100vw, 1017px\" \/><\/a><\/p>\n<p>This will remove the blank rows after each item!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/Screenshot-91.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Insert Blank Rows In a Pivot Table\"  class=\"alignnone size-full wp-image-22495\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/Screenshot-91.png\" alt=\"Insert Blank Rows In a Pivot Table\" width=\"607\" height=\"466\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/Screenshot-91.png 607w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/Screenshot-91-300x230.png 300w\" sizes=\"(max-width: 607px) 100vw, 607px\" \/><\/a><\/p>\n<p>Using the Design Tab, you can easily insert blank row in pivot table\u00a0or remove it!<\/p>\n<p><strong>Further Learning:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-fix-pivot-table-empty-cells-in-excel\/\" target=\"_blank\" rel=\"noopener\">How To Fill Blank Cells in Pivot Table<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/delete-blank-worksheets-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener\">Delete Blank Worksheets Using Macros In Excel<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/isblank-formula-in-excel\/\" target=\"_blank\" rel=\"noopener\">ISBLANK Formula in Excel<\/a><\/li>\n<\/ul>\n<p><span style=\"color: #0000ff;\"><strong>HELPFUL RESOURCE:<\/strong><\/span><\/p>\n<p><strong>Make sure to download our FREE PDF on the<a href=\"https:\/\/app.monstercampaigns.com\/c\/czseo0viyrmspcx5ndve\/\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">\u00a0333 Excel keyboard Shortcuts here<\/a>:<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Pivot Table reports are shown\u00a0in a Compact Layout format as a default and if you have two or more Items in the Row Labels (e.g.Month &amp; Customer), then the Pivot Table report can look very clunky&#8230; There is a cool little trick that most Excel users do not know about that adds a blank row [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":17128,"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":[717,86],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/2416"}],"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=2416"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/2416\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17128"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=2416"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=2416"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=2416"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}