Copying an excel worksheet

[alex]

I have a two worksheet excel document. The first worksheet has all the raw
data and formulas. The second worksheet has some nice table layout with the
final results imprted from the first worksheet.

What I need to do is copy just the data (results) and tables from the second
worksheet without any of the formulas or macros to a brand new excel
document that can be submitted for presentation.

I have tried highlighting all the cells in the first excel sheet and then
doing a copy and finally a paste in the new document, but get the message
"Data on the clipboard is not the same size and shape as the selected area.
Do you want to paste the data anyway?" If I say yes, all the formatting is
gone.

If instead, I do a copy in the first document and do a paste special and
paste as a Microsoft Office Excel Worksheet Object, all the formatting is
correct. However, eventhough I didn't copy the first worksheet with all the
formulas, this still shows up as a hidden worksheet that can be accessed by
simply doubleclicking on the new document.

Is there any any way to just copy the results and the formatting and
column/table width without copying the other worksheet?

Thank you

 

[Alan]

Try highlighting the whole sheet by clicking the blank grey bit on the top
left, the one above row 1 and to the left of column A. Right click there and
Copy, then in the same place in the new workbook, right click and Paste
Special > Values, then do the same again but with Paste Special > Formats.
You need to do it that way round because if there are any merged cells
you'll get the message 'Merged Cells Need To Be The same Size' if you paste
special the formatting first.
Regards,
Alan.

 

[alex]

I did try that but when I click in the top right on a new excel doc and go
paste special, I don't have options for values and format. I am using excel
2003 if that makes a difference.

The options I see are paste as:

Microsoft Office Excel Worksheet Object
Picture (enhanced metafile)
bitmap
microsoft excel 8.0 format
biff5
biff4
biff3
biff
slyk
wk1
dif
xml spreadsheet
html
unicode text
text
csv
hyperlink

 

[AltNrg4U]

Alex,
As usual, there are several ways to handle this.
One method is to right click on the second tab and create a copy of it.
If it happens to give some sort of message that you have more than 255
character, that is fine. Just do a complete copy and paste from the 2nd tab
to the third tab and this will recopy the characters greater than 255.
Once you have your full third tab (which should be identical to the 2nd tab
in every way except the tab name) copy the whole thing and resave only the
values. (Ctrl+A, Paste Special - Values)
Now this tab can be moved to a new workbook.

AltNrg4U

 

[Dave Peterson]

It sounds like you have two instances of excel open.

Close one of them and then use File|Open in the remaining instance to open the
second workbook.

Then do your copy|paste.

 

[Gail]

Right click on the worksheet you want to make a copy of, select Move/copy ,
check the Create a copy box, in the top box, select either the already set
up file you want the sheet in or select (new Workbook), Click Okay.

Now, select all your data in the new sheet, copy, paste special values

 

[alex]

Thank you, this worked really well