How can I select pivot table row totals to fill color them

R

Ruth5155

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
 
L

Luke M

From the PivotTable tool bar, Click on the PivotTable dropdown, select -
Enable selection.
 
D

de_koi

Ruth5155;937600 said:
I have a pivot table with total rows. Other people in my team at wor
can
hover over the left edge of one of the total rows and all total row
get
selected so that a fill color can be applied. It does not work for me
Click to expand...
==========================================================
hi,
you can try to reset your excel setup. Go to Help >> Detect and RepaiIt works for me so hopefully works for you too.
 

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

Excel VBA - counting cells by colors and names to it in two different rows. 0
Row Grand Totals in Pivot Tables? 8
Pivot Table Chart - Group Totals 1
How to include the Grand Total Column in a pivot table chart? 1
Pivot Table calc difference between two rows of data 1
How to add colum totals to a pivot chart data table 1
Question on the occupied field of the pivot table in excel spreadsheet 0
Pivot Table Row Totals 6

Top