Inserting an Excel worksheet into Word 1

[Eggles]

Word/Excel 2000 Win98

I had to insert a large completed and formatted worksheet into Word. I thought it would be easy....

I tried copying and pasting, but an odd character was present in every unfilled cell that I could not delete (and only showed when I had the Show/Hide button turned OFF!!!), The character (like a hollow square) showed up in the printed copy too. Both documents were in Arial.

In the end I resorted to saving the Excel file as a .csv, inserting that into Word, reformatting the text to Arial (it came in as Courier), converting the text to a table... but of course lost all formatting and had to spend ages redoing it. Also, many of the Excel cells contained a checkmark symbol, that reverted to a lowercase 'a' when I had completed all the steps described. I could not find a way of doing a Find/Replace to get those checkmarks back (I don't know how they were originally created), and there were hundreds of them so I just converted them all to whatever the equivalent to 'a' is in one of the 'symbol-type' fonts e.g. Wingdings (can't remember exactly which one I used in the end as I tried so many).

So my questions are: how SHOULD you get an Excel worksheet into Word? and how do you replace a symbol?

 

[PennyB]

Put the cursor where you want the spreadsheet to be inserted. Click on Insert>Object then click on "From File" and Browse. Find the file and click ok. (change the documet type to 'all files' first).

It should insert as you've formatted it.

HTH

Penny

 

[JoyInOK]

Office 2000 has some weird defaults for pasting. I usually copy the spreadsheet from Excel, then do an Edit/PasteSpecial from the toolbar. Try all the different format options (as formatted text, as HTML, as bitmap, etc.) until you get one close to what you need.