98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Word Training and help » Position embedded excel sheet in a word document | Word forum
Position embedded excel sheet in a word document | Word forum
Resolved · Urgent Priority · Version 2010
Beverley has attended:
Multiple applications course
Multiple applications course
Position embedded excel sheet in a word document
I have embedded an excel sheet in a word documents but it has created a lot of blank pages and I do not know how to reposition it within the word document
RE: Position embedded excel sheet in a word document
Hello Beverley,
Thank you for your post. Which method did you use to embed the spreadsheet? Did you copy and paste the selected cells or did you use Insert - Object? How large is the spreadsheet: one sheet or multiple sheets?
Kind regards
Marius Barnard
Office Trainer
RE: Position embedded excel sheet in a word document
Hello Marius -
I embedded the excel sheet over a month ago and to be honest I cannot remember how I did it. It is in a long word document with 27 pages and about 5 pages of excel with signatures space in word with names typed in at the bottom of 2 of the excel sheets and the schoool logo at the top of every sheet.
I have almost given back and I have gone to my old word document and I am inputting all the subtotals by hand. If it's not easy do not worry - but it would be handy if I had some instructions - I am unsure if I am trying to do the impossible or it is my lack of experience.
RE: Position embedded excel sheet in a word document
Hi Beverley,
If you don't need to link the copied Excel data between Word and Excel, the easiest is to highlight the Excel cells, then copy and paste them normally into Word. This will make the pasted data a normal Word table which you can move around with the square icon at the table's top left edge.
If the data needs to link to the original Excel, you can paste it as a link, then right-click the pasted data. Select "Format Object" and click the Layout tab. Choose "Behind text", then click OK. This way, you can easily move the inserted data around in the Word document.
I hope this helps.
Kind regards
Marius
Training information:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Word tip:Creating perfectly symmetrical shapesAre you a perfectionist when it comes to drawing shapes in Word? |