Excel Tip of the Day
Hide items in a PivotTable's page field's selection list (Excel 97/2000/2001/2002)
In a PivotTable, a page field is a dropdown list that lets you filter the PivotTable to show only the data associated with the selected field item. For example, if a PivotTable's page field is Country, you can filter the PivotTable to show just the data pertaining to Canada. Then, selecting France from the dropdown list alters the PivotTable to reflect the data associated with France. If you want to prevent items from appearing in the page filter's dropdown list, right-click on the page field's label ([control]-click on the Mac). Then, select Field Settings from the menu bar. Select the items you want to hide in the Hide Items list box and then click OK. By default, data associated with the hidden page field items is ignored from the PivotTable's totals.
(Content provided by Element K Journals)
(Note: Your browser is set to refuse cookies. As a result, you may frequently see previously-viewed tips)
Print
CloseCopyright © 2001 - 2025 MJ Technologies, LLC. All rights reserved.