» Hiding Items
CATEGORY - Excel Pivot Tables
VERSION - All Microsoft Excel Versions
In Excel 97, double-click the name of the leftmost Row field, and in Hide Items, select the item to hide, and then click OK.
In all other Excel versions, open the dropdown list of any field and cancel the selection of the items you wish to hide. To open the dropdown list using a keyboard shortcut, press Alt+Down Arrow (or Up Arrow).
CAUTION!
You must be very careful when reporting totals after hiding items in a PivotTable report. There is no indication in any field, page, row or column that one or more items are hidden (as opposed to other areas in Excel, for example, when using Automatic Filter in the Filter technique, the color of the dropdown list's arrow changes to blue). It is therefore highly recommended to insert a Comment in a cell to remind you of any hidden items.
Book Store:
Recommended Books:
- Marketing Planning for Services
- Harry Potter and the Order of the Phoenix (Book 5)
- Business Plans For Dummies®
- Advanced modelling in finance using Excel and VBA
- Real Estate Finance and Investments (Real Estate Finance and Investments, 11th Ed)
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
No comments have been submitted.
