LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
DATE FORMAT CHANGE FROM EXCEL WORKSHEET TO PIVOT TABLE Wendy Excel Discussion (Misc queries) 0 November 19th 08 12:54 AM
Change the name of the Data field in a Pivot Table John Excel Discussion (Misc queries) 2 October 6th 08 05:16 PM
can i change pivot table to change data jacob22 Excel Discussion (Misc queries) 2 April 11th 07 03:32 PM
pivot table format change mhutch71 Excel Discussion (Misc queries) 1 August 23rd 05 01:29 PM
Change Data In Pivot Table John Calder New Users to Excel 1 July 7th 05 10:41 PM


All times are GMT +1. The time now is 10:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"