| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Tables in Excel 2007
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pivot Tables in Excel 2007
Hi Misha,
You can hide the column heathers, in the Pivot table menu click on Field Headers "Misha" wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pivot Tables in Excel 2007
I mean the actual words, ' Column Headers' & 'Row Headers' in Excel 2007, not
2003. "Eduardo" wrote: Hi Misha, You can hide the column heathers, in the Pivot table menu click on Field Headers "Misha" wrote: 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pivot Tables in Excel 2007
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 wrote: 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 -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pivot Tables in Excel 2007
Thank you very much, That worked!
"Debra Dalgleish" wrote: 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 wrote: 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 -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot tables in Excel 2003 and 2007 | Excel Discussion (Misc queries) | |||
| Pivot Tables in Excel 2007 | Excel Discussion (Misc queries) | |||
| Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
| Excel 2007 Pivot tables | Excel Worksheet Functions | |||
| Bug with pivot tables corrupting in Excel 2007 | Excel Discussion (Misc queries) | |||
Linear Mode
