How to copy part of a sheet as a new sheet into another workbook?

[Guest]

Hi all,

Most part of my sheet is empty, so if i copy the sheet as a whole it will
take long, so I would like to copy part of it as a new added sheet into
another workbook. By the way, during the copy I need to keep the layout of
the new added sheet as the same as original one( especially the merged
cells), how can I do the two things?

Clara

 

[Guest]

I think you assumption is wrong. Copying the sheet should not take long.

If it does, you need to clean it up.

Unused cells past the UsedRange are usually virtual - so they take not time
to copy since they are not there and are not copied.

If you do Edit=>Goto=>special and select last cell and end up way past your
data, you need to clean up your sheet (delete entire rows and columns that
are unused - not cells, ENTIRE rows and columns). If you don't end up way
past your data, then it shouldn't take but a 'blink of the eye'.