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
|