Context Menu "Custom Format Cell" does not appear

[#1]

Hi at all,

i can't understand why the "Custom Format Cell" in the Context Menu of a Pivot Table does not appear.

I have selected "Advanced" in Document Settings but with no result!

Anyone know why there is this behavior?

Thanks in advance

Antonello

[#2]

Hi

The menu item doesn't seem to appear if you right-click the table caption, you must right-click inside the table.
Maybe that's your problem...

/Fredrik

[#3]

In fact...... when I right-click inside the table this voice does not appear

[#4 · Accepted solution]

Hi Antonello,

It's a litle bit late and you are certainly already find the solution, but for the others.

To have the "Custom Format Cell" in the Context Menu of a Pivot Table, you need to go to the menu "View" and active "Design Grid".

Best regards,

Sébastien Fatoux

[#5]

Or,

change the setting in USER PREFERENCES.

Good luck!

Rainer

[#6]

CrossSystems wrote:
Hi Antonello,
It's a litle bit late and you are certainly already find the solution, but for the others.
To have the "Custom Format Cell" in the Context Menu of a Pivot Table, you need to go to the menu "View" and active "Design Grid".
Best regards,
Sébastien Fatoux

Thanks Sébastien, i don't find the definitive solution. I don't understand why in certain situation this option does not appear!

[#7]

This helped me , i was clicking header from quite some time & then saw your line and hurray !!