Pivot - Different cell size of label and expression field

[#1]

I have a Pivot table where I have dragged down the expressions so they are shown on different rows to the left, with all corresponding values to the right, with a date on each column. My problem is that if I change the cell size for my values, the label cell gets the same size. Is it possible to have one size for the label and another for the value cells?

I have attached two images that shows my problem. What I would like to have is one size for the "Fiscal_YearPeriod" column and another for all cells to the right.

Version is 8.5.

[Miguel_Angel_Baeyens]

Hello,

To customize cell format, right click while pressed control key on the cell / dimension / expression which properties you want to change and select "Customize Cell Format". Working fine in v9.00 Give a try in your document.

Regards

[#3]

Hi Miguel and thanks for your reply.

whether I press the control key or not doesn't matter but if I right-click on the cell I get an option saying "Control Format Cell". There I can do some formatting regarding borders and color but unfortunately not cell size. Is this a possibility in version 9?

[Miguel_Angel_Baeyens]

Hello,

No, there's not any possibility. Take into account that you are ina pivot table and what you are really sizing is the FiscalYearPeriod, although this expression is horizontal, not vertical.

A macro solution is likely to exist, though.

[#5]

Ok, thank you again for your reply Miguel.