Suppressing Header row in Pivot table

[raghavsurya]

Hi All,

I need to hide the header row in a Pivot table. Is there a way to do it. Please let me know.

Regards,

Raghav

[#2]

In the Chart Properties, go to the Presentation tab, near the bottom on the left hand side, there is a check box for "Suppress Header Row".

Hope this helps.

[raghavsurya]

Hi Greame,

The option which you are suggesting is possible only in Straight table box. This option is not available for Pivot table.

Thanks and Regards,

Raghav

[brenner_martina]

Hi,

the easiest way is to change in custom cell format the text color!

[#5]

Hi

In custom format cell you can change background and text color to white.

Then you get a white header row.

Anders

[raghavsurya]

Hi,

Thanks all for your suggestions..... I have done it now 🙂

Regards,

Raghav

[nathanfurby]

...and how did you do it?

[#8]

Hi

Settings - User Preferences - Design

Mark "Always Show Design Menu Item"

Right click at the heading line and "Custom Format Cell"

There you can change the color.

Good luck

Anders

[nathanfurby]

Thanks Anders - I'm guessing that's how raghavsurya also did it

[#10]

how?