Paste Special

[EvansB2]

I want to copy over contents over a spreadsheet including the table to a new worksheet without the formulas. I have tried paste special using values, however the orginal table does not copy over and all the columns are wrong size.

Would appreciate help on this.

Regards

Ben

 

[yogeshmaney]

Use format painter

 

[ChrisM]

Do a second Paste-special, this time with "formats" as the only thing checked.

 

[EvansB2]

Cheers.

Ben