http://smmeyer.com/scribble/?p=41
I had difficulty resizing an embedded Excel sheet in MS Word. I’d edited the embedded object by opening it in Excel, but could not get the extra columns I added to show in Word. I tried to use Word’s crop feature but wasn’t satisfied with the level of control there because it wasn’t precise enough to fit to the column / row edges exactly resulting in messy display of the border lines.
I later discovered that you can do this if you choose the ‘Edit’ context menu item instead of ‘Open’. Then it opens in a sort-of frame in word instead of in a new window. Resizing the frame using the edge handles automatically snaps to the column / row boundaries in the spreadsheet and allows precise control so that border lines are displayed correctly.