problem fitting Excel sheet into Word doc

[Guest]

Someone tried to help me with this last night, but it didn't work all the
way. I am writing a business plan in Word and have three Excel worksheets
with financial data on them that I want to put at the end of the Word doc.
Word doc is in Portrait format and Excel is in Landscape (I finally figured
out how to get the three Word pages to be Landscape). The problem now is that
when i try and put each Excel sheet (15 columns x 55 rows) into Word it cuts
off everything past column J and below row 42. The missing data doesn't even
seem to be there because when I try and make the sheet smaller the data
doesn't come in from the left or the bottom. I've tried simple pasting,
inserting objects and tables. I'm pretty new at this so i hope I'm making
sense?

I'd appreciate any help I can get.

thanks!!

 

[garfield-n-odie]

I'm glad you figured it out.

 

[Guest]

Here is something you can try, but it will likely distort your text some, if
you have to make big adjustments.
Place your cursor in the correct spot in the Word Document.
Choose Insert | Object, Create from File.
Browse to Find your Excel Document.
Hit okay.
Switch to Web Layout View in Word.
Resize the Excel Object to fit on One page. You may want to use Format |
Object to make sure you maintain proprtions.

Word will only take from Excel whatever can be displayed on 1 sheet of
paper. So, you may need to adjust your margins. Or, you could change the Font
size in Excel.

tj