To highlight Header Rows/Columns or Banded Rows/Columns in Excel 2007

To highlight header rows/ columns or banded rows/ columns: 1. Select a cell in the PivotTable report. 2. Select PivotTable Tools Ribbon -> Desi...

PivotTable Styles in Excel 2007

To apply a style to a PivotTable report: 1. Select a cell in the PivotTable report. 2. Select PivotTable Tools Ribbon -> Design -> and selec...

Formatting a Value Field in Excel Pivot Table

The formatting of a value field must be saved in order to keep the formatting while creating Pivot Table & then structure is changed. Option 1:...

Handling Errors in Values & Empty cells in Excel 2007

To change the default options of showing empty cells or errors in values: 1. Select a cell in the PivotTable report, right click and select Table O...

Expand/Collapse Entire Items in a Field in Excel 2007

To expand/collapse entire items in a field: 1. Select an item in the Row Labels field area (2003 (item) in Years field, see screenshot below). 2. ...

Show/Hide Expand Items Buttons in Excel 2007

To show/hide expand items buttons: 1. Select an item in the Row Labels field area (2003 (item) in Years field, see screenshot below). 2. To hide t...

Displaying the Top/Bottom N Items in Excel 2007

To display the top/bottom N items: Select a cell in a Row Labels field -> right-click, select Filter -> Top 10. ...

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 Google PlusVisit Us On Youtube