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

position embedded excel sheet

Forum home » Delegate support and help forum » Microsoft Word Training and help » Position embedded excel sheet in a word document

Position embedded excel sheet in a word document

ResolvedVersion 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:

Keeping words together in the same line

Word will automatically wrap text itself to create new lines.

You can force Word to keep words together when they are separated by either spaces or hyphens by creating non-breaking spaces or non-breaking hyphens.

To create a non-breaking space, use Ctrl + Shift in conjunction with pressing the spacebar.

To create a non-breaking hyphen, use Ctrl + Shift in conjunction with pressing the hyphen key.

Non-breaking spaces or hyphens will not split between lines.

View all Word hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.