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

Select all subtotal rows on Pivot Table
 

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

Select all subtotal rows on Pivot Table
 

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