Change Pivot Table Report Layout Forms In Excel 2010
Excel 2010 offers three forms for pivot tables report layout which are; Compact Form (default), Outline Form, and Tabular Form. In this post we will look at how to change the form of a report layout.
For switching to different layout, navigate to Design tab and from Layout group, under Report Layout options, select desired layout
It will instantly add a blank row after each set of record.
Alongside report, you can also apply Grand Totals and Subtotal forms.
1 Comment
Leave a Reply
This site uses Akismet to reduce spam. Learn how your comment data is processed.
![Debian: Add user to Sudoers file [Guide]](https://cloud.addictivetips.com/wp-content/uploads/2021/01/debian-add-single-user-320x170.png)
SIR,
I WANT A PIVOT TABLE FOR BANK STATEMENT BUT DATA FORMAT CONTAIN DATE,TYPE,DETAILS,CREDIT, DEBIT ONLY, BUT PIVOT TABLE CONTAIN EXTRA HEADING BALANCE HOW IS IT…. POSSIBLE.