Insert Rows Between Each Line in Pivot Table

Apr 23

Insert Rows in Pivot Table

Hi there,

In this post, we will see how to insert rows between each line in pivot table. Actually, when you try to insert or delete any of the pivot row/column it throws an error which is more than a NH7 highway.

This is a trick which helps to insert one row for each line item in the pivot table. Here we go:

...

Goto PivotTable Tools (this will be activated only when you keep the cursor within the pivot table) --> Active Field (Group) --> Field Settings --> Layout & Print --> check mark - "Insert blank line after each item label" as shown below.

using this window we can insert rows in pivot table

That's it. magic works!!!

DID YOU INSERT ROWS IN PIVOT?

Please share your tips using below comments section on this topic. Let our viewers learn from your tips as well. If you like this tip, share it on your social networking sites by clicking on the icons placed around the blog.

CLICK HERE TO JOIN OUR FAMILY,

SOME IMPORTANT LINKS:

PivotTable width Unchanged

Pivot Cache and its Advantages

Kick-Off Unwanted Pivot Layouts

Collect Time in Hourly Brackets

Custom Grouping in Pivot Table

Few more...

Thanks,

You must be logged in to see the comments. Log in now!

If you have no account yet, you can register now! (It only takes a few seconds)