Maintain the size and format of Excel inside WORD

If you right click on the sheet in Word, and select Picture, Size, Scale, and set it to 100% you should get full size.  Keep in mind that if it doesn't fit in the page width Word will truncate the image.

---

»bp

keep the original size and format

On thing you can do is change the Word  page size to be large enough to hold all of the columns from excel.

In Excel, change to "Page Layout" (under the "View" bar of the ribbon).

There you will see separate pages extending from the left to the right each with columns on them.

 By highlighting tall of the columns on each "page" one "Page" at a time you will alaos move and highlight the Ruler that tells you how much space each section times up.

Add up the values of all of the columns on all of the pages, then add in some space for margins, and for Word formatting overhead (lest ssay 2-3 inches) and you have the minimum page size word will need to have to display your excel data as a table without scrunching it.

How about if I only want to add one line to the end of the worksheet but let WORD to show it, while keeping every size and format remain unchanged ?

THx