Mass format change of 'data' in pivot table

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?
 
T

trip_to_tokyo

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table date format 1
Pivot Table - Currency Format 1
Pivot Table - Changes 5
pivot table data 2
pivot table 3
How can I change the source data reference to another pivot table? 2
Single Filter to change all Pivot Tables in a Workbook 8
Adding multiple fields to a Pivot table at one time 1

Top