Tried that. The spreadsheet created in Word is a funky size, and when you try to make it the correct size, it stretches the words.

Like I said, I can do it six different ways in regular MS Word for Windows, but when I do it on Word 2004 for Mac, everything gets messed up. There are three different spreadsheets that need to be copied onto three separate pages within a Word doc. I made them all the same number of rows and columns, same size of rows and columns, font, etc. Nothing is different about the three documents. I have gotten to the point where I can copy them as pictures and they work wonderfully, except for one of them. It views in Word with black "censor" bars through the title of the spreadsheet, and prints from Word looking fuzzy. When I print the same thing straight from Excel, it looks fine. WHAT IS HAPPENING TO THIS STUPID DOCUMENT??!????!!!!!?????? I'm losing my mind.

I came across this by dint of trial and error the other day. This allows me to copy Excel information into a Word table ending up in native Word format so it looks as good as the text in the rest of the document (but no links I am afraid):

1. Select/Copy your Excel range.

2. Paste into Word. This is the same as paste Special/HTML Format.

The pasted range will be much too big for the page, however this is the trick to make it fit (all the rest is done in Word):

3. Select a range starting just before the beginning of the range just pasted, ending just after the end of the range (i.e. select OUTSIDE the area that you have just pasted; do not start or end your selection inside what was the Excel data).

4. Now convert this selected area to a Table, as follows:

Table/Convert/Text to Table [note that you should only have the Text to table ... option, the other one being greyed out].

5. When the Convert Text to table box appears, just click OK (no need to make any changes).

As if by magic, the Excel table will now be formatted as a Table within Word, fitting into the normal Word margins, and breaking across pages as you would expect of a normal Word table.

The Excel cell layout will be preserved, but there won't be any links to the original workbook. However, all the text will be in native Word format, so that you can re-format if required.

Your Excel data will appear in a Word table that appears to have an extra (blank) row top & bottom, and an extra (blank) column left & right. Apart from the top row, they resist deletion, so you will need to 'remove' the Borders from within Borders and Shading (select from the first blank row of the table to the end, and then delete the borders; they will still show in grey but will not show up in print).

This was AMAZING! Thank you so much. You've saved me so much time and hassle. Great instructions, too -- perfect amount of information. You win the prize of the day.