Pivot Tables in Excel 2007

[Misha]

Is there any way of deleting the 'Row Labels' &'Column Labels' heading in a
Pivot Table? Some of my colleagues find them rather distracting!
Thanks

 

[Eduardo]

Hi Misha,
You can hide the column heathers, in the Pivot table menu click on Field
Headers

 

[Misha]

I mean the actual words, ' Column Headers' & 'Row Headers' in Excel 2007, not
2003.

 

[Debra Dalgleish]

You can click on the heading cell and type a space character, to make
the cell appear empty.

Or, click on the Design tab on the Ribbon, then click on Report Layout.
Select Outline Form or Tabular Form.

 

[Misha]

Thank you very much, That worked!

You can click on the heading cell and type a space character, to make
the cell appear empty.

Or, click on the Design tab on the Ribbon, then click on Report Layout.
Select Outline Form or Tabular Form.



--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com