Setting the Number of Fields Displayed in Excel 2007

To set the number of fields displayed per column in the Page layout: 1. Select a cell in the PivotTable report. 2. Right-click and then select Tab...

Show/Hide Subtotals in Excel 2007

To show/hide subtotals of a PivotTable report: Select PivotTable Tools Ribbon-> Design tab -> Subtotals (in Layout Group). ...

Show/Hide Grand Totals in Excel 2007

To change the default of showing grand totals for rows or columns: 1. Select a cell in the PivotTable report, right click and select Table Options ...

Drag Fields into PivotTable Report in Excel 2007

To drag fields into PivotTable report areas: Choose and drag each field from the top box area in PivotTable Field List dialog box down into one of th...

PivotTable Field List Dialog Box in Excel 2007

Pivot Table Field List Dialog Box   Pivot table is the most amazing feature of Excel. We can use pivot table in Excel on daily basis to creat...

The PivotTable Tools Ribbon in Excel 2007

When PivotTable report is created the PivotTable Tools Ribbon appears at the right of the menu tabs. The PivotTable Tools Ribbon contains two tabs:...

Creating a PivotTable Report in Excel 2007

To create a PivotTable report: Step 1: Define a Name for source data 1. Select any cell in the source data, and press Ctrl+Shift+* or press Ctrl+...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube