Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
format pivot subtotals
When you use a pivot table and put subtotals in a field, you can change the
formatting on all of the same level subtotals by clicking on the left part of the cell containing one subtotal (mouse turns into an arrow). Any idea how to turn that feature on or off? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
format pivot subtotals
In Excel 2003, on the PivotTable toolbar, click the PivotTable button
Click Select, then click Enable Selection, to toggle from On to Off In Excel 2007, on the Ribbon, click the Options tab under PivotTable Tools In the Actions group, click Select, then click Enable Selection David wrote: When you use a pivot table and put subtotals in a field, you can change the formatting on all of the same level subtotals by clicking on the left part of the cell containing one subtotal (mouse turns into an arrow). Any idea how to turn that feature on or off? -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
format pivot subtotals
On Aug 19, 6:51*pm, Debra Dalgleish wrote:
In Excel 2003, on the PivotTable toolbar, click the PivotTable button Click Select, then click Enable Selection, to toggle from On to Off In Excel 2007, on the Ribbon, click the Options tab under PivotTable Tools In the Actions group, click Select, then click Enable Selection David wrote: When you use a pivot table and put subtotals in a field, you can change the formatting on all of the same level subtotals by clicking on the left part of the cell containing one subtotal *(mouse turns into an arrow). *Any idea how to turn that feature on or off? * -- Debra Dalgleish Contextureswww.contextures.com/tiptech.html Blog:http://blog.contextures.com Sometimes it works, sometimes it doesn't, especially iff you have multiple level of sub-total. Another issue with Preserve Cell Formatting with Update, when you refresh the data it would be OK, but when you change the page (let say you have a page field for Month, when you change from one month to the other all the formats are gone) and you have to individually format each page SUCKKKKKKKKKK :( |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can i add subtotals to subtotals in a pivot table? | Excel Discussion (Misc queries) | |||
Pivot Table Subtotals | Excel Discussion (Misc queries) | |||
how to stop subtotals in Pivot Tbl | Excel Discussion (Misc queries) | |||
Pivot Table Subtotals | Excel Discussion (Misc queries) | |||
bring back ability to format subtotals in pivot tables | Excel Discussion (Misc queries) |