Courses / PivotTables & PivotCharts
16. PivotTable styles and banded rows
Applying and customizing built-in PivotTable styles and alternating row/column banding for readability.
Excel (PivotTables)
PivotTable styles and banded rows
A PivotTable style controls the look of your PivotTable, and banded rows/columns are alternating shading that improves readability.
"I need my report rows to be easy to scan, even after users collapse groups or I refresh the data."
PivotTable styles are built-in or custom formatting templates you apply to a PivotTable; banded rows/columns add alternating fill to rows or columns to make large tables easier to read.
"I need my report rows to be easy to scan, even after users collapse groups or I refresh the data."
PivotTable styles are built-in or custom formatting templates you apply to a PivotTable; banded rows/columns add alternating fill to rows or columns to make large tables easier to read.