Pivot Table Formatting Question

[Guest]

I feel stupid asking this, but couldn't find the answer anywhere. When I
initially started working with pivot tables, I was able to select all like
items by placing my cursor to the extreme left of the row. This would allow
me to change the formatting in all the total fields (for example) at once.

I am no longer being able to select all like fields this way. Do any of you
geniuses know how I might enable this feature again?

Thanks in advance for your help.

 

[Debra Dalgleish]

To enable selection:

From the Pivot toolbar, choose PivotTable>Select
Click on Enable Selection

 

[Guest]

Thank you so much, Debra! You helped me once before and I really appreciate
you sharing your knowledge with others.

 

[Debra Dalgleish]

You're welcome! Thanks for letting me know that it helped.