Windows7 + Office '07



I clicked on the upper left corner of the spreadsheet that selected all, copied, selected paste special, Excel spreadsheet object in Word and the result was a light blue rectangle starting at ~1/3 into the vertical of the page, the balance of the sheet off the page and no contents.

It's likely the spreadsheet was too wide.

Isn't there a way to determine ahead of time if a sheet will fit?

What do I do in Word to give the imported sheet the widest possible target area assuming that Word will not do this on its own?

Doesn't Word have a mechanism to auto adjust import sizes?

Is there a better way of importing a spreadsheet in the manner that allows you to click on the sheet and the sheet then becomes an active worksheet?

Thanks,

Mark

Embedding the sheet as you have done is the way to go, as far as I know. As for layout, you can view page layout or print preview in Excel to see what will fit on a page. Viewing Excel on screen can otherwise be enormously deceptive.

I would also recommend setting a Print Area in Excel, to include only the part of the sheet you need. Select only this area and see how it falls on a page with the margins you have set for Word.