Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Feb 2008
    Posts
    1,009
    Thanks
    63
    Thanked 2 Times in 2 Posts

    Insert Object neatly into Word

    I have the following spreadsheet. I would like to insert the object on sheet1 into word. It would be appreciated if someone could assist me.
    Attached Files Attached Files

  2. Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    3,894
    Thanks
    0
    Thanked 188 Times in 172 Posts
    After copying & pasting the object into Word, I get one with dimensions of 18.89cm*13.28cm (w*h). Simply drag the width handle to increase the overall width to 19.2cm or more. Alternatively, you could use Paste Special with the 'Enhanced Metafile' option. The advantage of the latter is that you can then re-scale the entire object without worrying about text-wrapping issues that a plain paste has to deal with.
    Last edited by macropod; 2013-12-18 at 23:12.
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  4. #3
    5 Star Lounger
    Join Date
    Feb 2008
    Posts
    1,009
    Thanks
    63
    Thanked 2 Times in 2 Posts
    Hi Paul

    Thanks for the reply. I was inserting the object into word from Excel. I will copy and paste special with Metafile option

    Regards

    Howard

  5. #4
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    3,894
    Thanks
    0
    Thanked 188 Times in 172 Posts
    Another way, of course, would be to use Insert|Object>Create from File.
    Cheers,

    Paul Edstein
    [MS MVP - Word]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •