Reprimand Hide Field Settings For Free

Right-click any cell in the pivot table and select Show Field List from the menu. This will make the field list visible again and restore it's normal behavior. The field list will disappear when a cell outside the pivot table is selected, and it will reappear again when a cell inside the pivot table is selected.

Turn column and row field headers on or offClick the PivotTable. This displays the PivotTable Tools tab on the ribbon.To switch between showing and hiding field headers, on the Analyze or Options tab, in the Show group, click Field Headers.

Show or hide the Header RowClick anywhere in the table.Go to Table Tools > Design on the Ribbon.In the Table Style Options group, select the Header Row check box to hide or display the table headers.More items...

Annoyed by the Buttons, Remove Them You can manage the field buttons on the ANALYZE tab on the POWERCHART TOOLS. If you want to turn all the buttons off, you only need to click the Field Buttons button which will look unselected and all the buttons are gone.

To hide the PivotTable Field List just needs one step. Right click at any cell of the pivot table, and select Hide Field List option from the context menu. If you want to show the Field List again, right click at the pivot table, and select Show Field List.

Step 1: Click the Pivot Chart that you want to hide/show field buttons to activate the PivotChart Tools in Ribbon. Step 2: Under the Analyze tab, click the field Buttons to hide all field buttons from selected Pivot Chart.

When you create a pivot chart, you'll see something called "field buttons" sitting on top of the chart area. In the upper left, you'll see buttons for value fields, which correspond to values being plotted in the chart. You'll also see a button to filter axis or category values.