Change Pivot Table Report Layout Forms In Excel 2010

Advertisement

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

774d1277113282-change-pivot-table-layout-reports-

It will instantly add a blank row after each set of record.

773d1277113277-change-pivot-table-layout-reports-

Alongside report, you can also apply Grand Totals and Subtotal forms.

Advertisement
  • MUBEEN

    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.