Mass format change of 'data' in pivot table

  • Thread starter Thread starter DME777
  • Start date Start date
D

DME777

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?
 
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!
 
Back
Top