« LOGNORMDIST Function | FTEST FUNCTION » |
Insert Rows in Pivot Table
Pivot TutorialHi 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.
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:
Pivot Cache and its Advantages
Kick-Off Unwanted Pivot Layouts
Collect Time in Hourly Brackets
Custom Grouping in Pivot Table
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)
Recent comments