Pivot Table

S

Steve

Hi

I'm ok at creating Pivot tables but have a question.

The table i have created has a lot of lines in when you take into account
the sub information (in the rows). It goes down to line 2000(ish).

There is the option of hiding and showing information by clicking the + or -
button which will show or hide the information for that particular person in
my caase.

My question is: Is there a way to open up or close them all at once rather
than do the 112 people individually?

Many Thanks

Steve
 

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

PIVOT TABLE help 1
Question on the occupied field of the pivot table in excel spreadsheet 0
Pivot Table - 3
Pivot table - Problem with % 5
Surpressing rows and columns with zero values in a pivot table 1
how to drag multiple items to pivot table report at once 0
One pivot table for multiple worksheets/tabs 2
Information for Pivot Table 3

Top