Tip Printed from ExcelTip.com

---

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 -> Design -> and select one or more check boxes in PivotTable Style Options Group.