PivotTable Title

I have Excel 2007. I have a PivotTable and want to have a title for it. When
I change "Data" to the title I want, it truncates the title in that first
cell. I tried merging the rest of the horizontal cells in the Data row, but
that is not allowed. Is there a way to have a nice title in the report itself?

Hi when I use pivot tables and need a pretty title, I cheat. I use the blank
line above as the title. and colour the other to the same colour font as the
background, thus not seeing it. Obviously you will have to be in a position
you don't want to change the selection.

Simple, but it works for me. There might be something else.

Cheers
Gai

"NonTechie" wrote:

I have Excel 2007. I have a PivotTable and want to have a title for it. When
I change "Data" to the title I want, it truncates the title in that first
cell. I tried merging the rest of the horizontal cells in the Data row, but
that is not allowed. Is there a way to have a nice title in the report itself?

Thanks, Gai. That is a great work-around suggestion. I do a lot of "cheating"
sometimes to get what I want. I guess it's not really cheating but "using all
the capabilities of Excel." :-)

"GaiGauci" wrote:

Hi when I use pivot tables and need a pretty title, I cheat. I use the blank
line above as the title. and colour the other to the same colour font as the
background, thus not seeing it. Obviously you will have to be in a position
you don't want to change the selection.

Simple, but it works for me. There might be something else.

Cheers
Gai

"NonTechie" wrote:

I have Excel 2007. I have a PivotTable and want to have a title for it. When
I change "Data" to the title I want, it truncates the title in that first
cell. I tried merging the rest of the horizontal cells in the Data row, but
that is not allowed. Is there a way to have a nice title in the report itself?