Center data in PIVOT table ?
Posted by Steven on December 11, 2001 7:55 PM
Short question: is is possible to center data in a pivottable ? I have wide headings per column and my values are now aligned at the right hand side of the datafields (which is not very easy to read).
Or do I need VBA for to align the values in the datafield ?
Note that the column headings (!) can be aligned simply by using the center option in Excel. The data unfortunately are NOT centered with this option.
Thanks in advance