How to fit excel sheet in a word document so that it will fit without chuncked off when I embedded a sheet in word.
I copied Excel sheet and did paste special to a word document then It did not paste whole excel sheet, part from the right is truncated.
I tried Inserting as an object then also it is pasting differently,
That is the reason, I am thinking of making the excel sheet fit to a sheet with no scroll bar, then I want to insert into word document.Please advice what to do!!!
Please help me with this problem
I will really appreciate your help.
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
When I insert an Object from the excel sheet, I am not getting whole excel sheet, right part is truncated. Can you please advice what to do? I did try changing the size from format object properties.
But I have right part chuncked off. It did not get full excel sheet when I insert an object referencing to an excel sheet.
No need to double-click the spreadsheet. Right click the spreadheet > Format Object > Size
What you need to do it once the spreadsheet is in the word document is to treat it as if it is a graphic i.e., a picture. The size tab of the Format Object should do what you need as it works well for me when I tested it.
Hi Pallilu,
I too have had this problem and managed to solve it in the following manner. It is a bit laborious but it does work!
1. Open a new word doc
2. Go to page setup and set the page to landscape and custom size page width to say 50cms (or whatever you need for your spreadsheet to appear fully on the page
3. Either copy and paste or insert the spreadsheet to the doc.
4. All columns will display and you can reduce the size by dragging the corners
5. If this is not enough to fit the normal size document you can resize the individual fonts etc until you get the whole sheet into your doc, then cut and paste into whatever normal doc you want...anyway you get the idea!
If any of this is not clear post again and I will try to help some more.
Good luck
Gayle
Business Accounts
Answer for Membership
by: Mob-bomPosted on 2004-01-07 at 08:08:11ID: 10062855
Hi pallilu
When you insert the excel file as an object into your word document, right click the excel spreadsheet, choose Format Object... > Size and adjust the size of the spreadsheet to fit to your Word doc. Doing this will shrink the spreasheet's fonts et. al. to accomodate the size parameters of the Word doc.