ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Naming a Pivot Table??? (https://www.excelbanter.com/excel-discussion-misc-queries/70192-naming-pivot-table.html)

ddawg09

Naming a Pivot Table???
 

I created a Pivot Table, and I have to give it a name. How do I do
this? There is no place connected to the Pivot Table to add a title.


--
ddawg09
------------------------------------------------------------------------
ddawg09's Profile: http://www.excelforum.com/member.php...o&userid=31205
View this thread: http://www.excelforum.com/showthread...hreadid=509617


Debra Dalgleish

Naming a Pivot Table???
 
Right-click on the pivot table, and choose Table Options
In the Name box at the top, type a name.
Click OK

ddawg09 wrote:
I created a Pivot Table, and I have to give it a name. How do I do
this? There is no place connected to the Pivot Table to add a title.




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html


ddawg09

Naming a Pivot Table???
 

Debra Dalgleish Wrote:
Right-click on the pivot table, and choose Table Options
In the Name box at the top, type a name.
Click OK

ddawg09 wrote:
I created a Pivot Table, and I have to give it a name. How do I do
this? There is no place connected to the Pivot Table to add a

title.




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html



I did that but still nothing appears above the table. Am I doing
something wrong?


--
ddawg09
------------------------------------------------------------------------
ddawg09's Profile: http://www.excelforum.com/member.php...o&userid=31205
View this thread: http://www.excelforum.com/showthread...hreadid=509617


Debra Dalgleish

Naming a Pivot Table???
 
The name won't appear above the pivot table -- it's only visible in the
PivotTable Options dialog box.

You could type a name on the worksheet, above the pivot table.

ddawg09 wrote:
Debra Dalgleish Wrote:

Right-click on the pivot table, and choose Table Options
In the Name box at the top, type a name.
Click OK

ddawg09 wrote:

I created a Pivot Table, and I have to give it a name. How do I do
this? There is no place connected to the Pivot Table to add a


title.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html




I did that but still nothing appears above the table. Am I doing
something wrong?




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html



All times are GMT +1. The time now is 04:00 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com