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 you add these blank rows..

DOWNLOAD EXCEL WORKBOOK

STEP 1: Click in the Pivot Table and go to Pivot Table Tools > Design > Blank Rows

STEP 2: 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:

insert blank rows pivot table

STEP 3: To get rid off the blank rows you can press the CTRL+Z shortcut or from the Blank Rows button select Remove Blank Line After Each Item

Insert Blank Lines

HELPFUL RESOURCE:

728x90

 

 

 

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

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin