How to hide selected items in pivot table?
In pivot table, sometimes, you may want to hide one or more of the items, Excel provides an easy feature for you to deal with this job, to know more details about this feature, please browse the following article.
Hide selected items in pivot table with Filter feature
Hide selected items in pivot table with shortcut keys
Hide selected items in pivot table with Filter feature
In pivot table, to hide selected items, please do as follows:
1. Select the item that you want to hide, and right click to choose Filter > Hide Selected Items, see screenshot:
2. And then your selected item will be hidden immediately. See screenshots:
 |
 |
 |
Note: You can use the Keep Only Selected Items option to keep your selected items visible.
Hide selected items in pivot table with shortcut keys
Except using the above method, here also have quick shortcut keys to solve it.
1. Select the items you want to hide first.
2. Then press Ctrl + - keys to hide the selected items.
Related articles:
How to hide subtotals in pivot table?
How to hide expand collapse buttons in pivot table?
How to hide zero value rows in pivot table?
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
