1. You are viewing our forum as a guest. For full access please Register. WindowsBBS.com is completely free, paid for by advertisers and donations.

printing EXCEL gridlines in WORD

Discussion in 'Other PC Software' started by scb, 2004/02/15.

Thread Status:
Not open for further replies.
  1. 2004/02/15
    scb

    scb Inactive Thread Starter

    Joined:
    2002/09/23
    Messages:
    10
    Likes Received:
    0
    I have just switched to XP Office (2002) from Office 1997 and am encountering a problem I never had with the old Office. I can copy a portion of an Excel spreadsheet successfully into WORD (with gridlines), but when I print, the gridlines are not printed. This is not a printer specific problem. The "print gridlines" box is checked in EXCEL. Any advice on how to get the gridlines printed would be welcome.
     
    scb,
    #1
  2. 2004/02/15
    Newt

    Newt Inactive

    Joined:
    2002/01/07
    Messages:
    10,974
    Likes Received:
    2
    If you print the same section directly from Excel, do you get the gridlines on the printed output?
     
    Newt,
    #2


  3. to hide this advert.

  4. 2004/02/15
    scb

    scb Inactive Thread Starter

    Joined:
    2002/09/23
    Messages:
    10
    Likes Received:
    0
    Yes, I do. Thank you for helping me with this.
     
    scb,
    #3
  5. 2004/02/16
    Newt

    Newt Inactive

    Joined:
    2002/01/07
    Messages:
    10,974
    Likes Received:
    2
    I just did a little testing.

    Copy from excel and

    - paste to word = no grid lines
    - paste as chart = gridlines
    - paste as .bmp = gridlines (but hogs lots of space for no good reason)
    - paste as picture = gridlines and the least size increase in the word doc
    - paste as enhanced metafile picture = gridlines

    I didn't try with the excel piece as a live link but my guess is that would work as well.

    The .bmp option not only increased the size of the word doc more than the other options but also gave by far the poorest rendering of the spreadsheet piece. Mostly it left the outer border no darker than the internal gridlines so not nearly as easy to read.
     
    Newt,
    #4
  6. 2004/02/16
    Christer

    Christer Geek Member Staff

    Joined:
    2002/12/17
    Messages:
    6,585
    Likes Received:
    74
    I just did that in Office XP (2002).

    I created the grid lines in Excel and did a copy/paste into Word. On the screen all columns but the left-most are black. The left-most is grey.
    It prints the black grid lines but not the grey ones.

    In Word, after marking the area of the spread sheet, I recreated the grid lines and on the next attempt, all of them were printed.

    Christer
     
    Last edited: 2004/02/16
    Christer,
    #5
  7. 2004/02/16
    scb

    scb Inactive Thread Starter

    Joined:
    2002/09/23
    Messages:
    10
    Likes Received:
    0
    Many thanks to both of you. I will try it tomorrow at the lab and see how it goes.
     
    scb,
    #6
  8. 2004/02/17
    scb

    scb Inactive Thread Starter

    Joined:
    2002/09/23
    Messages:
    10
    Likes Received:
    0
    I used the Insert -> Object -> Excel chart function and it did print. But what an onerous way to get a spreadsheet into Word. I hardly think this is an improvement. Thank you for the guidance.
     
    scb,
    #7
Thread Status:
Not open for further replies.

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...