Pivot Table Drill Down

  • Thread starter Thread starter John Kiser
  • Start date Start date
J

John Kiser

When I double-left click on a cell in a pivot table, I can
drill down and see the underlying data; however, it shows
me this data in another worksheet. To close my view of
the data, I have to remove that worksheet by deleting it.

For a lot of drilling down, that's a lot of time and
keystrokes.

Question...have I missed an easier method of closing the
drilled-down data worksheet?

Thanks
 
AFAIK, there's no other way to view the detail. You could save the
worksheet before you start drilling, view the detail, then close without
saving.
 
Back
Top