Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default Hide Pivot Field Labels?

I'm havin' a dingity-dang heck of a time getting a handle on the Pivot Field
Labels so I can hide certain of them. What's the answer?
Excel '97. References show Excel Object Library version 8.0 if memory
serves.
Is this available via the PivotItem only?

Thanks In Advance

Desi


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Hide Pivot Field Labels?

If you mean page fields, drag them to the row area, make you unselections,
drag back.

--
Regards,
Tom Ogilvy


"Desi" wrote in message
...
I'm havin' a dingity-dang heck of a time getting a handle on the Pivot

Field
Labels so I can hide certain of them. What's the answer?
Excel '97. References show Excel Object Library version 8.0 if memory
serves.
Is this available via the PivotItem only?

Thanks In Advance

Desi




  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default Hide Pivot Field Labels?

Huh?
How does one do this at runtime? And these happen to be column fields,
although I suspect it works similarly.

Desi

"Tom Ogilvy" wrote in message
...
If you mean page fields, drag them to the row area, make you unselections,
drag back.

--
Regards,
Tom Ogilvy



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I repeat labels in Excel for a pivot table field? sonya Excel Discussion (Misc queries) 3 July 1st 08 09:55 PM
Automatically Hide Pivot Table Field List Box RB Excel Discussion (Misc queries) 1 May 28th 07 12:21 PM
pivot chart is it possible to hide individual field buttons? Layout Field buttons Matt Charts and Charting in Excel 0 August 27th 06 02:57 PM
How do i hide the field list in a pivot table? sherobot Excel Discussion (Misc queries) 0 May 9th 06 12:30 AM
Hide a data field on a pivot table cb Excel Programming 0 February 13th 04 07:58 PM


All times are GMT +1. The time now is 03:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"