| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove "sum of" from pivot table name large quantities
I know how I can remove the "sum of" term from the column name of my
data field in a pivot table by adjusting the field properties. However, I have many, many columns and it's very tedious to remove it from each one. Is there an easier way to change the field names? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Remove "sum of" from pivot table name large quantities
Select the range
Edit|Replace what: sum_of_ with: _ replace all the underscore represents a space character. Notice that the change still leaves a leading space in the field name. FSUKC wrote: I know how I can remove the "sum of" term from the column name of my data field in a pivot table by adjusting the field properties. However, I have many, many columns and it's very tedious to remove it from each one. Is there an easier way to change the field names? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom field in Pivot Table? | Excel Discussion (Misc queries) | |||
| OLAP Pivot table - How to show items with no data ? | Excel Worksheet Functions | |||
| How to remove Drop Page Fields Here from Pivot Table | Excel Discussion (Misc queries) | |||
| How do I remove the individual subtotal lines from a pivot table.. | Excel Discussion (Misc queries) | |||
| how to remove "(All)" in a pivot table using VBA | Excel Discussion (Misc queries) | |||
Linear Mode
