Mass format change of 'data' in pivot table
 

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

Mass format change of 'data' in pivot table
 

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