How do you convert a pivot table to excel worksheet

M

MS at CORE

How do you convert a pivot table to a regular excel worksheet? All I can
find are instructions on how to convert excel worksheet to a pivot table but
not the other way around. I do not have a data source file since the pivot
table was e-mailed to me. I need to combine this file with excel worksheet
to sort data to compare and find missing information from excel worksheet.

Thank you for your help!
 
H

HKaplan

Do you mean copying the data displayed in the pivot table into excel
as a regular table? If so, you can highlight the cells and copy then
paste into another area.

Or do you want the underlying data as well?
 
M

MS at CORE

I was hoping to find a quicker way than copying and pasting but I guess not.
Thank you for your help!
 

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

Top