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

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

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

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