ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How can I select pivot table row totals to fill color them (https://www.excelbanter.com/charts-charting-excel/259141-how-can-i-select-pivot-table-row-totals-fill-color-them.html)

Ruth5155

How can I select pivot table row totals to fill color them
 
I have a pivot table with total rows. Other people in my team at work can
hover over the left edge of one of the total rows and all total rows get
selected so that a fill color can be applied. It does not work for me

Luke M[_4_]

How can I select pivot table row totals to fill color them
 
From the PivotTable tool bar, Click on the PivotTable dropdown, select -
Enable selection.

--
Best Regards,

Luke M
"Ruth5155" wrote in message
...
I have a pivot table with total rows. Other people in my team at work can
hover over the left edge of one of the total rows and all total rows get
selected so that a fill color can be applied. It does not work for me




de_koi

Quote:

Originally Posted by Ruth5155 (Post 937600)
I have a pivot table with total rows. Other people in my team at work can
hover over the left edge of one of the total rows and all total rows get
selected so that a fill color can be applied. It does not work for me

================================================== ========
hi,
you can try to reset your excel setup. Go to Help Detect and Repair Discard my customize setting and restore default settings start. It works for me so hopefully works for you too..


All times are GMT +1. The time now is 07:40 PM.

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