Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
PivotTables headings formatting ?
Two questions regarding PivotTables headings formatting:
1) How can I choose not to show the pre text "Sum of" or "Count of" in column headings in Pivottables? Using "Format report" I manage to do this on my computer (Excel 2003 English) but when using the same Pivottable on a client computer (Excel 2003 Swedish) all the headings include the text, and I cant get rid of it. 2) Using the function "Format report" (and alternative 1) on the same client computer results in the grand totals for rows and columns disappearing from the Pivottable, despite that those options are marked in Table options. Are grand totals sometimes incompatible with the format report function? Grateful for answers... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deferring conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional Formatting: "handwritten" circles? | Excel Discussion (Misc queries) | |||
Paste Link - retaining formatting | Excel Discussion (Misc queries) | |||
conditional formatting with formula | Excel Worksheet Functions | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |