Pivot Headline Modification

[#1]

Hello,

I created a Pivot table, bute the Headlines looking not as wished. Can some help me how to mofify the Headlines with color or to this bold?

Thx in advance.

Heiko

[awhitfield]

Hi Heiko,

1. enable 'View > Design Grid'

2. Right click on the cell in question and select 'Custom Cell Format'

3. Select the required settings, as shown below:

HTH - Andy

[rubenmarin]

Hi Heiko, in USer preferences (CTRL+ALT+U), 'Design' tab, check 'Always show design menu options' (or something similar)

After that right-click on any of those values on the top row-->'Custom cell format'--> check Bold

[#4]

Hi Andrew,

thx for the quick help. That was perfect.

Could you maybe also help how to sort the data inside the pivot table always for the actual year?

[cid:image002.png@01D0D691.1815D3B0]

As you see on that picture, the result is not structured.

The Table should always be sorted from big to small in the current year.

Thx in advance

Heiko

Von: Andrew Whitfield

Gesendet: Freitag, 14. August 2015 12:44

An: Gündling Heiko

Betreff: Re: - Pivot Headline Modification

[#5]

Thank you Ruben,

quick and good help.

Regards

Heiko

Von: Ruben Marin

Gesendet: Freitag, 14. August 2015 12:46

An: Gündling Heiko

Betreff: Re: - Pivot Headline Modification