If you're sharing an Excel pivot table with colleagues who aren't too skilled in Excel, you might want to hide some of the buttons and drop downs in the pivot table before you send it.

For example, in the pivot table shown below, the sales are summarized by city and product, and has filter buttons and expand/collapse buttons showing.

Hide the Buttons

You 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:

Right-click a cell in the pivot table and, in the popup menu, click PivotTable Options. On the Display tab, remove the check mark from Show Expand/Collapse Buttons. This hides the buttons to the left of the outer Row Labels and Column Labels. Remove the check mark from Display Field Captions and Filter Drop Downs. This hides the filter buttons, and the

Continue reading Hide Pivot Table Buttons and Labels