I don't want to manually tweak font and table dimensions. Ideally the whole thing should scale to fit the page.
I'm using the 2007 version for both.
The above shows an Excel File inserted within a Word file, (Insert - Text - Object - Create from File - browse from your HDD)
If you single click over the block, 8 anchor points will appear in the boundary and moving them will change the size of image.
However if you double click on the block, entire Excel file will open and there will be 8 anchor points, by moving which the part of file visible within word changes. It has to be column-width wise and row-height wise, you can display or hide part row/ part column.
Then double click outside the block or press escape and the block will remain in word in its new size.
Try highlighting the cells containing the desired rows and columns and going to Word and right click Paste Special.
You may be able to default the Word Document to the Font you want.
This is not a perfect solution as you just want to paste the cells into word and have them look right.
From my experience you are better off working to make your Excel Document Printable by setting the Print Area etc and forget about using Word for more than few columns.