Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Jeff Borden
 
Posts: n/a
Default Pivot Table - 'Merge Labels' option and formatting

When I turn on the 'Merge Labels' option in the Pivot Table Options dialog,
it seems to force all the row item labels to be aligned centre.

For example, I can select the second column of labels and align them left,
but as soon as I refresh the table they all pop to centered again.

Is there any way I can have the 'merge labels' option turned on, but still
control the row label alignment?
--
Jeff Borden
Reply
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
cell formatting?? and making it so that it will move to the first option on a listing ratt Excel Worksheet Functions 1 August 17th 05 01:53 PM
Pivot Table - Preserve Formatting Ms MIS Excel Worksheet Functions 1 May 18th 05 01:01 PM
How do I change the category axis number formatting in a Pivot Ch. Cultcab Charts and Charting in Excel 0 April 19th 05 12:26 AM
pivot table results - with value in every row and column PivotMan Excel Discussion (Misc queries) 3 February 15th 05 09:27 PM
Pivot table irritation Excel Worksheet Functions 2 December 31st 04 07:09 PM


All times are GMT +1. The time now is 11:36 PM.

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

About Us

"It's about Microsoft Excel"