» 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:
- The One Page Business Plan: Start With a Vision, Build a Company!
- Real Estate Loopholes: Secrets of Successful Real Estate Investing
- Financial Statements: A Step-By-Step Guide to Understanding and Creating Financial Reports
- Microsoft Access 2002 for Dummies
- How to Use Financial Statements: A Guide to Understanding the Numbers
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
No comments have been submitted.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
