In this Pivot Table, the Dept field is used for a Report Filter.  - ProProfs Discuss
Topics-
Products +
     

In this Pivot Table, the Dept field is used for a Report Filter.  How can you get all of the different departments to automatically display on their own separate sheet tabs at the bottom of the workbook?



A. You would need to view each department as a separate Pivot Table first, then copy the worksheet to its own tab
B. Options contextual tab, Options icon, Show Report Filter Pages, OK
C. Display all departments, Options contextual tab, Move Worksheet icon, choose \New Worksheet\, OK
D. Design tab, Move Pivot Table icon, \Move to Individual Worksheet\, OK
E. I don t know the answer to this question.

This question is part of Excel 2010 Skills Assessment
Asked by Carlson, Last updated: Dec 05, 2017

+ AnswerRequest Answer
...

2 Answers

John Adney

John Adney

Answered on Jan 23, 2017

Ok. Thanks a lot,
 Reply

John Smith

John Smith

Answered on Nov 21, 2016

Options contextual tab, Options icon, Show Report Filter Pages, OK
 Reply

Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer

Email Sent
We have sent an email to your address "" with instructions to reset your password.