Pivot Table reports are shown in a Compact Layout format as a default and if you have two or more Items in the Row Labels (e.g.Month & Customer), then the Pivot Table report can look very clunky

clunky pivot table report

There is a cool little trick that most Excel users do not know about that adds a blank row after each item, making the Pivot Table report look more appealing.

Here is how to insert a row in Pivot Table!

Insert Blank Rows In a Pivot Table | MyExcelOnline

Follow a step-by-step tutorial on how to insert row in pivot table and download this workbook to move along with us:

DOWNLOAD EXCEL WORKBOOK

 

STEP 1: Click any cell in the Pivot Table

Insert Blank Rows In a Pivot Table | MyExcelOnline

STEP 2: Go to Design > Blank Rows

Insert Blank Rows In a Pivot Table | MyExcelOnline

STEP 3: You will need to click on the Blank Rows button and select Insert Blank Line After Each Item

NB: For this to work you will need at least two Pivot Table Items in the Rows Labels

insert blank line

You then get the following Pivot Table report:

how to insert a row in pivot table

This tutorial shows you how to insert rows in pivot table and will make the Pivot Table look clean and more appealing.

You can easily remove this blank row from Pivot Table as well!

METHOD 1: Simply press CTRL +  Z if you have recently inserted a blank row.

METHOD 2: Go to Design > Blank Row dropdown > Select Remove Blank Line After Each Item.

Insert Blank Rows In a Pivot Table | MyExcelOnline

This will remove the blank rows after each item!

Insert Blank Rows In a Pivot Table | MyExcelOnline

Using the Design Tab, you can easily insert blank row in pivot table or remove it!

 

HELPFUL RESOURCE:

Make sure to download our FREE PDF on the 333 Excel keyboard Shortcuts here:

Microsoft Excel Training

You can learn more about how to use Excel by viewing our FREE Excel webinar training on FormulasPivot TablesPower Query, and Macros & VBA!

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

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn