Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Feb 2010
    Location
    Florida
    Posts
    11
    Thanks
    1
    Thanked 0 Times in 0 Posts
    I create tables in Excel 2007 and need to paste them preserving all the formatting into Word 2007 docs. In prior versions I used paste-special picture which worked perfectly. The Excel table is placed in the document with no grid lines appearing or printing. In Word 2007 the non-printing grid lines in the Excel table become visible and printing grid lines in Word 2007. Does anyone know how to eliminate the gridlines? I am using Office 2007 SP2. Your help is appreciated.

  2. #2
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts
    2 options
    From the Excel end, turn off the display of gridlines and then copy paste as picture into word. Because it is taking a picture - it won't include the gridlines.
    From the Word end, do a default paste and then select the table and turn off the borders.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  3. #3
    New Lounger
    Join Date
    Feb 2010
    Location
    Florida
    Posts
    11
    Thanks
    1
    Thanked 0 Times in 0 Posts
    The first method through Excel works just fine. I thought that I had remembered trying that previously with no success but alas I was wrong.

    Thank you.

  4. #4
    WS Lounge VIP
    Join Date
    Mar 2006
    Location
    Maryland, USA
    Posts
    690
    Thanks
    17
    Thanked 66 Times in 56 Posts
    Also, if you choose HTML format for the paste special, Excel's formatting will be retained.

    Pam
    Pam Caswell

Posting Permissions

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