| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you convert a pivot table to excel worksheet
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do you convert a pivot table to excel worksheet
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do you convert a pivot table to excel worksheet
I was hoping to find a quicker way than copying and pasting but I guess not. Thank you for your help! "HKaplan" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I convert a Pivot Table to a regular Excel worksheet? | Excel Discussion (Misc queries) | |||
| Convert Pivot table back to Data Table | Excel Discussion (Misc queries) | |||
| convert Pivot table back to Data table | Excel Discussion (Misc queries) | |||
| Convert Pivot Table to Normal Data table | Excel Discussion (Misc queries) | |||
| convert excel list to pivot table | Excel Discussion (Misc queries) | |||
Linear Mode
