Inserting an excel file as object into word

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I try to insert an excel object to into word I get one of two problems;
either the inserted object is too wide and I can't reduce the width of of the box without altering the size of the text (this is after unlocking the size ratio) or
I get a box that is the correct width but misses off about 1/3 of the text from the bottom of the excel text.
I have tried changing all sorts of different settings, does anyone have any suggestions?
Sue
 
Hi Sue

99 times out of 100 I find that it's best to paste ranges or charts from
Excel as a picture.

To do this, select the object in Excel as usual, and do Edit > Copy as
usual. In Word, do Edit > Paste Special, and paste as a picture. If you want
to link the picture to the Excel file, then choose the link option.

In Word, this thing will now behave like any picture, and you can move it
around, stretch it, and re-size it as you would any picture.

Hope this helps.

Shauna Kelly. Microsoft MVP.
http://www.shaunakelly.com/word


Sue said:
When I try to insert an excel object to into word I get one of two problems;
either the inserted object is too wide and I can't reduce the width of of
Click to expand...
the box without altering the size of the text (this is after unlocking the
size ratio) or
I get a box that is the correct width but misses off about 1/3 of the text
Click to expand...
from the bottom of the excel text.
 
This is great, thank you.

Shauna Kelly said:
Hi Sue

99 times out of 100 I find that it's best to paste ranges or charts from
Excel as a picture.

To do this, select the object in Excel as usual, and do Edit > Copy as
usual. In Word, do Edit > Paste Special, and paste as a picture. If you want
to link the picture to the Excel file, then choose the link option.

In Word, this thing will now behave like any picture, and you can move it
around, stretch it, and re-size it as you would any picture.

Hope this helps.

Shauna Kelly. Microsoft MVP.
http://www.shaunakelly.com/word



the box without altering the size of the text (this is after unlocking the
size ratio) or
from the bottom of the excel text.
Click to expand...
 
Back
Top