excel from pivot table back to original data

jimjohn

Board Regular
Joined
Nov 14, 2007
Messages
107
can somenoe plz help me with this:
i have a pivottable in excel with many different filters, but now i want to be able to see my original data set. for example, if i double click one of the cells in the pivot table, it will show me a part of the original data set given various filters e.g. but how do i get to see my whole original data set? thanks!
 

Some videos you may like

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
36,103
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
Remove all row, column and page fields, just leaving a data field. Then double click the data field and you should get all the detail data shown.
 

jimjohn

Board Regular
Joined
Nov 14, 2007
Messages
107
sorry this is a pretty dumb question but hwo do i remove alkl the other fields? what do i click on and then how do i get my original data? ive never used pivottables before and just want to see the original data. thanks so much!
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
36,103
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
You should be able to just click and drag the field headers off the pivot table to remove them.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,863
Messages
5,598,504
Members
414,245
Latest member
Major Aly

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top