| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I can not select Pivot Table on my Data Menu | Excel Discussion (Misc queries) | |||
| pivot table error (25000 rows!!) | Excel Discussion (Misc queries) | |||
| Pivot Table Report formatting - can't select Data Source Order | Excel Discussion (Misc queries) | |||
| Subtotal vs Pivot table - or best way | Excel Discussion (Misc queries) | |||
| subtotal - pivot table - or better function | Excel Worksheet Functions | |||
Linear Mode
