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

Lock the Excel Pivot Table but not the Slicer Sometimes when you are sharing an Excel Pivot Table with your colleagues you do not want the other user(s) to mess with your Pivot Table layout and format. What you can do is lock the Pivot Table and only allow the user(s) to select the Slicers, making your report interact...
Sort Field List In a Pivot Table from A to Z Do you ever get in a situation where your Pivot Table Field List has over 20 fields and you spend heaps of time trying to locate one within the Field List? Well you can save time by sorting the Pivot Table Field List in alphabetical order! To do this you need to Right Click...
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...
Show Pivot Table Values As a Running Total In If you want to track your sales on a monthly basis and see their Year to Date totals, then you can easily do this with the Running Totals In calculation. You can activate this by Right Clicking on your Pivot Table values and choosing Show Values As and Running Total In.  You c...