Excel 2003 - Pivot Table - Hide Field Headings

adamdc20

New Member
Joined
Apr 10, 2006
Messages
18
Hi - thanks in advance to anyone who can assist me with the following:

I have created a pivot table and I want to be able to hide the field heading (which at the moment says Data and has a drop down arrow next to it).

How can this be done?

Thanks
 

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
Well, you could overtype the cell (button) so that it says something other than Data, or you could apply a custom format to it along the lines of:

;;;

(3 semi-colons) which would blank out the displayed value.

You won't be able to actually hide an individual cell (only a row or column) so you will still see the dropdown arrow. You can probably hide the dropdown arrow using VBA.
 

adamdc20

New Member
Joined
Apr 10, 2006
Messages
18
Thanks for this - I'll go with the custom format option. It seems as though Excel 2007 has an option to remove these headers.

Thanks so much
 

Watch MrExcel Video

Forum statistics

Threads
1,099,624
Messages
5,469,777
Members
406,669
Latest member
Rubrob

This Week's Hot Topics

Top