ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Hide Pivot Field Labels? (https://www.excelbanter.com/excel-programming/356457-hide-pivot-field-labels.html)

Desi

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



Tom Ogilvy

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





Desi

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





All times are GMT +1. The time now is 10:06 PM.

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