Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Virginia, USA
    Posts
    1,560
    Thanks
    37
    Thanked 1 Time in 1 Post

    Paste from Excel (2003)

    A colleague is trying to put an Excel worksheet into a Word document, and I'm trying to help with little luck. We came close to success with this approach: In Excel, I selected the range of cells he wants to put into the document; (2) I right-clicked and selected Copy; (3) in Word, I clicked Edit > Paste Special... > Microsoft Office Excel Worksheet Object. The resulting image was too big for the page, so I grabbed the resizing handles and dragged to make the worksheet fit. So far, so good, except that the worksheet displayed with a rather dark gray background. There are no gridlines, and that's what we want.

    Then my colleague tried doing the same thing. We have identical computers with identical software setups. However, the image he gets has a plain white background (good) and it displays the gridlines (not good).

    My specific question is why do we get different results? In general, is there a better way to get the results we want?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Paste from Excel (2003)

    The difference is probably due to field shading. If you paste as an Excel worksheet object, Word inserts a field into the document (EMBED or LINK , depending on whether you paste a link).
    The View tab of Tools | Options lets you specify how fields are shaded - always, only when selected, or never. If the field is shaded, the gray shading masks the grid lines. You'll still see them in print preview and in the printed output.
    If you don't want gridlines, you should hide them in Excel (Tools | Options..., View tab) *before* copying the cells to the clipboard.

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Virginia, USA
    Posts
    1,560
    Thanks
    37
    Thanked 1 Time in 1 Post

    Re: Paste from Excel (2003)

    By Jove, we've got it! A big thank you <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15>from Ray and Lucas!

Posting Permissions

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