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

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Running Total In % with an Excel Pivot Table A Running Total In is the accumulation of values over a certain period, like days, month or years.  It is sometimes referred to as the Year to Date analysis.A Running Total In takes one period's values, then adds a second period, then a third period...and so on, to give the a...
Protected: What Else Can Excel Pivot Tables Do?  The Pivot Table Webinar Replay & Xtreme Pivot Table Online Course is Closing its Doors in...Click Here To Watch The Webinar ReplayBONUS VIDEO:   Consolidate Multiple Sheets & Excel TablesIn this training you are going to learn the following:C...
Group By Month With Excel Pivot Tables Before I was a Pivot Table guru, I had to get individual rows of daily sales and group them into a report showing the monthly sales during the year.Grouping these would take a ton of effort using Formulas:Extracting the month and year from each transactional date; Th...
Pivot Table Count Transactions The default Value Field Setting when analyzing data with a Pivot Table is to Sum, but you can also analyze a Pivot Table with a Count.This is useful when you want to see how many sales transactions  took place within a region, a month, a year or per business unit.DOWNLOAD...