Pivot to Create New TAB / Worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

Pivot tables used to be able to create a new page for selected data. what /
where is that functionality?

How do I get "Show Pages" to work?

Thanks
Tracey
 
Select a cell in the pivot table
On the Ribbon, click the Options tab
In the PivotTable group, click the dropdown arrow for Options
Choose Show Report Filter Pages
Select a filter, and click OK
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

calculated field in pivot - how to edit 3
Creating pivot table to Existing worksheet 1
Excel VBA For excel 0
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Create new worksheets per pivot page field 3
Pivot table data source 1
Pivot table creation in excel 1
Workbook pivot table design function 6

Back
Top