ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Shading of Multiple Rows in a Pivot Table (https://www.excelbanter.com/excel-worksheet-functions/186681-shading-multiple-rows-pivot-table.html)

JanT

Shading of Multiple Rows in a Pivot Table
 
How do you shade multiple total rows in a pivot table on one click?

Debra Dalgleish

Shading of Multiple Rows in a Pivot Table
 
To format cells, enable selection should be turned on.
To enable selection --
From the Pivot toolbar, choose PivotTableSelect
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


JanT wrote:
How do you shade multiple total rows in a pivot table on one click?



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html



All times are GMT +1. The time now is 07:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com