Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / General Excel Questions / January 2008

Tip: Looking for answers? Try searching our database.

How do you convert a pivot table to excel worksheet

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
MS at CORE - 18 Jan 2008 21:08 GMT
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!
HKaplan - 18 Jan 2008 21:25 GMT
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?
MS at CORE - 18 Jan 2008 22:50 GMT
I was hoping to find a quicker way than copying and pasting but I guess not.
Thank you for your help!

> 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?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.