Position embedded excel sheet in a word document | Word forum

Resolved · Urgent Priority · Version 2010

Mon 13 Oct 2014, 12:46 Delegate Beverley said...

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

Mon 13 Oct 2014, 13:45 Trainer Marius said...

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

Mon 13 Oct 2014, 13:50 Delegate Beverley said...

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.

Mon 13 Oct 2014, 14:16 Trainer Marius said...

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

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

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