Pivot Table question

reemoe

New Member
Joined
Oct 24, 2005
Messages
41
I was told that Pivot Tables have the ability to 'explode' the data and create worksheet tabs automatically. Is this true? How is it done?

Thanks in advance!
Ryan
 

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
7,988
Try double clicking on the bottom right cell in your pivot table (the value associated with grand total).

In fact, try double clicking on just about any area in a pivot table to make it "explode"
 

Watch MrExcel Video

Forum statistics

Threads
1,118,451
Messages
5,572,193
Members
412,447
Latest member
immy
Top