Categorized | pivot table

Hide Pivot Table Field Header – Pivot Table Quick Tip

When you create a pivot table in Excel 2007, the pivot table field headers get inserted automatically. The headers make the job of slicing the data easier but they also have an unintended side effect – they make the first column to become much wider than the rest.


One way out is to adjust the width of the first column to make it match the other columns and then disable the ‘autofit’ feature using the pivot table options. There’s another option that you can use – simply hide them.

Click on anywhere within the pivot table. Then from the ribbon, pick up the ‘options’ tab and then click the ‘Field Headers’ button. A single click does the trick !

The pivot table appears far neater than it did earlier and as you can see, all the columns are now equally spaced out automatically. If you need to sort or hide values, you can turn them right back on.

Excel Formula, Excel Chart, Excel Macro, Excel VBA, Pivot Table Excel, Excel Dashboard

What Do You Think ?

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Comments and Trackbacks

  1. Keyboard Shortcuts in Excel to Sort, Add, Hide Pivot Table Items and Fields | Excel & VBA - da Tab Is On wrote:

    […] any pivot field header (the label for the pivot field) and presss SHIFT + CTRL + = (Shift key then Ctrl key then =). The […]


Keep up with the latest stories - Delivered right to your inbox


English flagItalian flagKorean flagChinese (Simplified) flagPortuguese flagGerman flagFrench flagSpanish flagJapanese flagArabic flagRussian flagDutch flagHindi flagFilipino flagIndonesian flagThai flagTurkish flagPersian flag
treeemap software for excel