transfer one worksheet to another worksheet without losing format.

[Guest]

I am using Office XP, Excel...I am trying to transfer multiple worksheets
into a new workbook. When I copy and paste or insert it as an object, I lose
the formatting, and the columns which I had hidden reappear. How can I
transfer/copy my worksheets into a new workbook without losing the formatting
and unhiding the columns?

 

[Guest]

I am using Office XP, Excel...I am trying to transfer multiple worksheets
into a new workbook. When I copy and paste or insert it as an object, I lose
the formatting, and the columns which I had hidden reappear. How can I
transfer/copy my worksheets into a new workbook without losing the formatting
and unhiding the columns?

First you need to open a new workbook and leave it open. I would recommend
naming and saving it. Second, go to the workbook which contains the worksheet
you would like to move. Go the the worksheet tab at the bottom of the screen
and right click on the worksheet name (it might be worksheet 1 or something
else). From that menu, select Move or Copy. The Move or Copy window will then
appear. In the "To book:" area select the name of your new workbook. If
you would like the sheet placed in a particular area, select the appropriate
"Before sheet:" location. Then check the box "Create a copy". Finally select
OK. You will then have the worksheet moved to another workbook with the
formatting preserved.