Excel Pivot Table Tip - Show Pages
Ever want to create multiple pivot tables on separate tabs from one original pivot table? David Carter’s Show Pages tip shows you how to do it.
Tip #3 - Use the Show Pages command to generate pivot tables for Page fields automatically
If you use Page fields in a pivot table, you can use the Show Pages command to create a new worksheet for each page. So if the Page field contains Department codes, for example, Show Pages will automatically create a pivot table for each department.
In earlier versions of Excel, the Show Pages command is easy to find. But in Excel 2003 it has been removed from the Pivot Table menu and hidden away in the menu bar.
If you are using Excel 2003: Right click the mouse on the pivot table to call up the pivot table menu. Select Show Pivot Table toolbar. In the toolbar, click on the down arrow next to ‘Pivot Table’ at the left. Show Pages is at the bottom of the menu.
Leave a Comment
If you would like to make a comment, please fill out the form below.
You must be logged in to post a comment.
