View Single Post
  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

To enable selection:

From the Pivot toolbar, choose PivotTableSelect
Click on Enable Selection


marmur1 wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html