If it's too big, you may have to break the spreadsheet into pieces, pasting it piecemeal, page by page.
Of course, if you paste it in RTF, you'll get a table that could break across pages. If the table is too wide, then select the table and, in the Word menu, go to "Table/Autofit/Autofit to Window". That'll squeeze it.
In general, I've found the whole process you're going through to be a bit buggy, so patience or appropriate medication is called for.
Tom
For worksheets too large for Word, a workaround is to change to a smaller font size in Excel, adjust column widths as necessary, copy, then Paste-Special as picture in Word. Resize the image as necessary. You may have to play around with the font size in Excel until you get one sufficiently small.
my Excel worksheet is already perfect in size.. i have to copy page 1 in page break preview and paste it on page 1 of word document as picture.. then, copy page 2 of excel to page 2 of word as picture.. and so on.. is there a way to do this automatically? coz ive got 300 pages.. and at least 5 of this file.. any idea?
i am familiar with writing code in excel vba but no idea at all on word..
No fancy page setup please.
No Fit to....just use Actual size.
Save the file.
Then copy/paste into Word.
If you've got a table that's 1.5 pages wide in Excel, don't expect it to fit to 1 page wide in Word.
Sometimes, making the paper size in Word really big, pasting and resizing the Excel object, THEN setting the paper size to desired, can also help alot.
http://www.officearticles.com/word/mail_merge_letters_in_microsoft_word.htm
Or you may want to try what's called a Catalog merge... check the help file.
#If you have any other info about this subject , Please add it free.# |
- edit
