Here is another great feature of pivot tables. Set up the table right and you can then automatically see all different options in a field. You don't have to change the view one at a time.
This feature is called Show Pages. For it to work, you need to have a page field in the pivot table, as we have in our example below.
Follow along in the Pivot Table Pages file.
Here is the pivot table we set up that you saw in a prior lesson.
We could click on the page field at the top, Rep, and change the view one rep at a time.
But what if we wanted to create a new worksheet for each rep, rather than one at a time? Excel gives you that option.
To do so, right click on the toolbar area (in blank area right of Help) to bring up the Pivot Table toolbar.
Alternatively, you could highlight a cell in the pivot table and right click to display a menu with an option to display the Pivot Table toolbar.
Once you have the toolbar up, click the down arrow near the bottom left, then select Show Pages.
Up comes the Show Pages dialog box.
If you had more than one field in the Page field section of the pivot table, you could select which ones you want to show the pages for. Since we have just one, we will go ahead and click OK.
As shown in the bottom, sheets have been created for all 10 reps in our example.
You have just seen how the Show Page feature for pivot tables allows you to quickly create multiple views of your report without having to do it one at a time.