when copying a worksheet to a new one, some of the information do.

[Guest]

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 ?

 

[Guest]

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

 

[Dave Peterson]

Maybe you could copy the worksheet itself (rightclick on the worksheet tab),
then clean up that copy.