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

Share on Google+

Google+

Related Posts

Conditionally Format a Pivot Table With Data Bars Data Bars are a new Conditional Formatting feature in Excel 2010 and they add a colored bar to your values. The length of the data bar represents the value in the cell.  A longer bar represents a higher value. You have a Gradient Fill or a Solid Fill to choose from as well ...
Pivot Charts & Slicers In a previous post I showed you how to Insert a Pivot Chart.  Now we will take this concept once step further and insert a Slicer.  The cool thing about this is that the Slicer will control both the Pivot Table and the Pivot Chart. See how you can start creating some awesome i...
Group Dates with a Pivot Table Grouping Dates is very easy with a Pivot Table.  All you have to do is Right Click on your Date values (which are either in the Row or Column Labels of your Pivot Table), then choose the Group option.  From the dialogue box you can choose to Group by Days, Months, Quarters or Yea...
How To Fix Pivot Table Empty Cells I am sure that you have come across a Pivot Table which has empty cell values and thought "What the hell is happening here?" This is because your data source has blank cells for certain items, which happens from time to time. This can be fixed in your Pivot Table and you ca...