When you insert a pivot table, there will be a PivotTable Field List popping out in the right section of the worksheet. Sometimes this PivotTable Field List may hide the data in the right of worksheet. Now I will tell you how to hide the PivotTable Field List in Excel. Show Office Tab Enable Tabbed Editing and Browsing in Office, and Make Your Work Much Easier... Read More... Free Download... Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
Read More... Free Download... Hide/show PivotTable Field List with right clickAmazing! Using Efficient Tabs in Excel Like Chrome, Firefox and Safari!Save 50% of your time, and reduce thousands of mouse clicks for you every day!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. For example, in the pivot table shown below, the sales are summarized by city and product. There are filter buttons on the Column heading, and on the Row Labels heading. At the left of the date, there is an expand/collapse button showing. Hide the ButtonsYou can change the pivot table options to hide some of the buttons and captions in the pivot table. Follow these steps to hide the buttons:
Pivot Table Buttons and Labels HiddenWithout the buttons and labels, the pivot table looks cleaner, and may be easier for your colleagues to read. By default, all columns, rows, and their field values appear when you create a pivot table. You can hide columns and rows that you don't want to appear in the pivot table without changing the pivot table values. When you have more than one measure in the pivot table, you can also hide values. At any time, you can choose to show any hidden fields in the pivot table. When you publish the visual as part of a dashboard, anyone who subscribes to the dashboard can export the pivot table to a comma-separated value (CSV) or Microsoft Excel file. They can choose to export only the visible fields, or all fields. For more information, see . To hide a column or row in a pivot table
To hide values in a pivot table
To show a hidden field in a pivot table
To show all hidden fields in a pivot table
How do I hide the top row in a PivotTable?Hiding rows and columns in a table. Activate the pivot table.. Click the category label for the row or column you want to hide, then click the label again to select the entire row or column. ... . Right-click the category label and from the menu, choose Hide Category. ... . From the View menu, choose Hide.. How do I hide a field header?Show or hide the Header Row. Click anywhere in the table.. Go to the Table tab on the Ribbon.. In the Table Style Options group, select the Header Row check box to hide or display the table headers.. How do I hide details in a PivotTable?Right-click the item, click Expand/Collapse, and then do one of the following:. To see the details for the current item, click Expand.. To hide the details for the current item, click Collapse.. To hide the details for all items in a field, click Collapse Entire Field.. |