What I would do is make two identical worksheets and delete in each one
what's not needed. If you click on the empty gray block about Row 1 and to
the left of Col. A, it's selects the entire worksheet including column sizes.
Copy and paste into a new worksheet, and then delete in each one what you
don't want in each one.

Connie Martin


"AZ" wrote:

I had a long spreadsheet that I wanted to break in 2. I created a new
worksheet and copied the rows and columns that I needed to copy.
When I was done, column "A" was not copied and the rest of the columns were
misalligned.
Any suggestions please ?