| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
to copy pivot table as new sheet with same format
How I can copy a pivot table to another worksheet without missing its format.
But in the new worksheet should behave as normal sheet can possible to insert a new column , delete a column . Please kindly request ur advice Pol |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
to copy pivot table as new sheet with same format
Select the entire table, copy, and pasted keeping the source formatting in a
new worksheet. "pol" wrote: How I can copy a pivot table to another worksheet without missing its format. But in the new worksheet should behave as normal sheet can possible to insert a new column , delete a column . Please kindly request ur advice Pol |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
to copy pivot table as new sheet with same format
I did copy keeping source , But I cannot insert a new column on the new
worksheet. How I can insert a new column on that new sheet With thanks Pol "Gilbert" wrote: Select the entire table, copy, and pasted keeping the source formatting in a new worksheet. "pol" wrote: How I can copy a pivot table to another worksheet without missing its format. But in the new worksheet should behave as normal sheet can possible to insert a new column , delete a column . Please kindly request ur advice Pol |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
to copy pivot table as new sheet with same format
You can't insert a column because you copied & pasted the pivot table as a
pivot table. Copy & paste the table you just pasted on the new sheet in place as values. Then, unless you have no unused columns or an exotic problem involving hidden objects, you should be able to insert a new column. Hope this helps, Hutch "pol" wrote: I did copy keeping source , But I cannot insert a new column on the new worksheet. How I can insert a new column on that new sheet With thanks Pol "Gilbert" wrote: Select the entire table, copy, and pasted keeping the source formatting in a new worksheet. "pol" wrote: How I can copy a pivot table to another worksheet without missing its format. But in the new worksheet should behave as normal sheet can possible to insert a new column , delete a column . Please kindly request ur advice Pol |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy a pivot table to another sheet in a macro | Excel Discussion (Misc queries) | |||
| Pivit table- cell on spread sheet referencing pivot table field | Charts and Charting in Excel | |||
| VB code to copy sheet format to another sheet | Excel Discussion (Misc queries) | |||
| How do I copy a print format from sheet to sheet in excel ? | Excel Discussion (Misc queries) | |||
| Pivot table Format Style Sheet Capability | Excel Discussion (Misc queries) | |||
Hybrid Mode
