Pivot Table Formatting Question

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.

To enable selection:

From the Pivot toolbar, choose PivotTable>Select
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

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


"Debra Dalgleish" wrote:

> To enable selection:
>
> From the Pivot toolbar, choose PivotTable>Select
> 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
>
>

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

marmur1 wrote:
> Thank you so much, Debra! You helped me once before and I really appreciate
> you sharing your knowledge with others.
>
>
> "Debra Dalgleish" wrote:
>
>
>>To enable selection:
>>
>> From the Pivot toolbar, choose PivotTable>Select
>>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
>>
>>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html