» Hiding Items
CATEGORY - Excel Pivot Tables
VERSION - All Microsoft Excel Versions
To hide items in a PivotTable report: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:
- The New Financial Order: Risk in the Twenty-First Century
- The 11 Immutable Laws of Internet Branding
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!
- Finance and Accounting for Nonfinancial Managers
- The Intelligent Investor: The Classic Bestseller on Value Investing
- Windows XP All-in-One Desk Reference For Dummies
No comments have been submitted.
