View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
trip_to_tokyo[_2_] trip_to_tokyo[_2_] is offline
external usenet poster
 
Posts: 70
Default 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