Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Doesn't the following give you what you want:-
Click in the Pivot Table (anywhere) / PivotTable Tools / Design / PivotTable Styles - there are many in here that you can choose from. If my comments have been helpful please hit Yes. Thanks! "DME777" wrote: On pivot tables, when I want the format the 'data' area fields, I select each data field individually and make the changes. Is there a way to change multiple data fields at once so that I don't have to select each one separately and make the same changes? Is there a way to change one data field and copy it to other data fields and have the format changes stick? -- DME |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
DATE FORMAT CHANGE FROM EXCEL WORKSHEET TO PIVOT TABLE | Excel Discussion (Misc queries) | |||
Change the name of the Data field in a Pivot Table | Excel Discussion (Misc queries) | |||
can i change pivot table to change data | Excel Discussion (Misc queries) | |||
pivot table format change | Excel Discussion (Misc queries) | |||
Change Data In Pivot Table | New Users to Excel |