How to remove Grey area

[prma7799]

Hi All,

How to remove grey area from the below pivot table ....

[Anil_Babu_Samineni]

Not possible

[sushil353]

Directly it is not possible.. but you can think of putting a text box over the area

[its_anandrjs]

As Sushil suggest you have to make trick for this

Ex:-

1. Text box layout properties should be Top over the pivot table.

2. Pivot table properties should be bottom.

3. Text box background color should be white or your define colour

HTH

Regards

Anand

[devarasu07 · Accepted solution]

Hi

It can be done, try to change the Cell color background transparency to 100%.

like below screen

[Anil_Babu_Samineni]

It deserve, But we need to hide cells too. Recently i faced same issue. But, Fortunately not due to limitation of pivot table. And i got some clue from Manish thru Whatsapp an easy way we can do using Macro to achieve. I am trying to do the same.

[its_anandrjs]

This works only when sheet background is white else it shows the color of your sheet.

Regards

Anand

[devarasu07]

Hi Anand,

Yeah. if you want both (remove pivot gray color and apply custom header color) then we have go try with macro option.

Thanks, Deva

[Frank_Hartmann]

Can you publish the macro code?

[Frank_Hartmann]

Can you publish the macro code?