Select all subtotal rows on Pivot Table

On my computer, I am able to select all the sub-total rows in a pivot table
at one time by clicking on edge of the box holding the row number. This will
select all the sub-total rows for that field so that I can format them for
easier reading.

My supervisor was able to do this a while ago, but recently has lost that
functionality. We are both running XP and Excel 2003. He has openned
spreadsheets that I've formatted this way and not been able to select all the
sub-total rows together, and I've openned spreadsheets he's worked on and
been able to select all the rows together. Is there some setting in Excel
that he may have unwittingly changed? Right now we are using Auto-Format as
a work around, but would like to be able to do it the other way.

TIA,
Marcotte

Try this:

Right-click on the Pivot Table
Select "Select" from the shortcut menu
Select: Enable Selection

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Marcotte A" wrote:

> On my computer, I am able to select all the sub-total rows in a pivot table
> at one time by clicking on edge of the box holding the row number. This will
> select all the sub-total rows for that field so that I can format them for
> easier reading.
>
> My supervisor was able to do this a while ago, but recently has lost that
> functionality. We are both running XP and Excel 2003. He has openned
> spreadsheets that I've formatted this way and not been able to select all the
> sub-total rows together, and I've openned spreadsheets he's worked on and
> been able to select all the rows together. Is there some setting in Excel
> that he may have unwittingly changed? Right now we are using Auto-Format as
> a work around, but would like to be able to do it the other way.
>
> TIA,
> Marcotte

Thanks Ron. I did that on my machine and it now reproduces my supervisors
problem. Enabling Selection then solved the problem. Thanks.

Marcotte

"Ron Coderre" wrote:

> Try this:
>
> Right-click on the Pivot Table
> Select "Select" from the shortcut menu
> Select: Enable Selection
>
> Does that help?
>
> ***********
> Regards,
> Ron
>
> XL2002, WinXP-Pro
>
>

I'm having the same issue with not being able to select all subtotals in a pivot table. However, when I right click in the report I don't have the option to select -->enable, etc.

I'm using 2010.