If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
PivotTable Title
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? |
#3
|
|||
|
|||
PivotTable Title
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? |
Thread Tools | |
Display Modes | |
|
|