Pivot Table Source Data

  • Thread starter Thread starter Billy
  • Start date Start date
B

Billy

I think I remember being able to take a pivot table view of data and
"double-click" on something (like the column headings or the whole
sheet) and a new sheet would be created showing all the background
data used to form the pivot table. If you know how to do this, could
you please describe the steps for doing this?
 
If your pivottable shows a grand total cell (usually in the bottom right
corner), try double clicking on that cell.
 
Back
Top