Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Formatting
Hi,
I use pivot tables a lot and often use the facility where you highlight pivot table subtotals and put them in yellow for example. This is where you can highlight the first subtotal and it will automatically highlight all other subtotals in the report. So the changes you do to one subtotal happen to all and allow refreshing etc. My colleague at work has tried to highlight all subtotals but he can't do it - does anyone know why this is? Thanks Beccy |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Formatting
Enable Selection may not be turned on:
Select a cell in the pivot table On the PivotTable toolbar, choose PivotTableSelectEnable Selection Beccy wrote: I use pivot tables a lot and often use the facility where you highlight pivot table subtotals and put them in yellow for example. This is where you can highlight the first subtotal and it will automatically highlight all other subtotals in the report. So the changes you do to one subtotal happen to all and allow refreshing etc. My colleague at work has tried to highlight all subtotals but he can't do it - does anyone know why this is? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Derived Columns in Pivot Table | Excel Discussion (Misc queries) | |||
Pivot Table formatting in office 2003 | Excel Discussion (Misc queries) | |||
Pivot Table Report formatting - can't select Data Source Order | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
Pivot Table Drill Down Number Formatting | Excel Discussion (Misc queries) |