Shading of Multiple Rows in a Pivot Table

  • Thread starter Thread starter JanT
  • Start date Start date
To format cells, enable selection should be turned on.
To enable selection --
From the Pivot toolbar, choose PivotTable>Select
If it's not already activated, click on Enable Selection

To format a section of a pivot table, e.g. column headings --
Move the pointer to the top of the column field button in the pivot table.
When the black arrow appears, click to select the column headings Format
the selected headings
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Shading rows 2
Comparison of columns using Conditional Formatting 3
Multiple measures in MS Access pivot table-Sigma Value in Row not Column 0
Average of Subtotals in Pivot Table 0
Shading of rows 8
Conditional Formatting in a Pivot Table 2
Pivot Table Row Totals 6
Alternate Row Shading (Visible Rows Only) 9

Back
Top