Maintain the size and format of Excel inside WORD

The attached word has embedded an Excel object. If I add a column and  row in the Excel, the format and size of the content are changed. Any idea where I can keep the original size and format of the WORD ?

Thx
test.docx
Simon LeungAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Bill PrewIT / Software Engineering ConsultantCommented:
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
Ben Personick (Previously QCubed)Lead SaaS Infrastructure EngineerCommented:
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.
2019-05-21-13_46_05-Disruptions-Feb1.png
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.
Simon LeungAuthor Commented:
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
Ben Personick (Previously QCubed)Lead SaaS Infrastructure EngineerCommented:
@Simon, to be frank I find keeping the formatting straight from excel to word or outlook a nearly impossible almost manual task.

So I use Microsoft One-Note instead when I need to combine text and data and then paste intk outlook, or I do it entirely in excel and forgo having a word doc at all

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.