position embedded excel sheet

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum 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

resolvedResolved · 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 courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Word tip:

Creating perfectly symmetrical shapes

Are you a perfectionist when it comes to drawing shapes in Word?

If you hold down the Shift key whilst drawing a shape from the Drawing toolbar, you can create perfectly symmetrical circles and squares; and perfectly straight lines.

View all Word hints and tips


Server loaded in 0.09 secs.