Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 18 of 18

Thread: Non-printing cell border...why?

  1. #11
    New Member
    Join Date
    May 2002
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks Art, for a thoughtful reply. That is what is so squirrelly about this! I have gone into borders and check all sorts of cells along the row, from above and below. They all look fine. Also, I check that the color is indeed black or auto. No problem there. All I can think of is that it has something to do with the gridlines. I don't know, but the solution is to move everything. YUCK. Thanks for trying anyhow!

  2. #12
    Board Regular
    Join Date
    Mar 2002
    Location
    North Wales Coast, UK
    Posts
    95
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,
    Thought I would join the fray.
    Have you tried Format Painting a 'good' row to the next?
    Even copying a 'good' row to over write the offending row to see if it makes a difference?
    Any Hidden row considerations?
    Or Conditional formatting?
    Just a few shots in the dark.
    S

  3. #13
    New Member
    Join Date
    May 2002
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Okay...This is the WEIRDEST thing, there HAS to be an answer. Here's what's happening now. I had done all the stuff I could think of that are "normal," including (yes) format paiting, checking color of borders, etc. I guess it's relevant to explain that I inherited this file, so I did have to check everything. In between the VERY KIND responses from y'all, I was fiddling around and changed the line width. What did that do? IT MOVED (YES MOVED!) the missing border to another spot on the page. Then I went in and redid all the borders, but rather than do them for the columns being used, I highlighted the whole row. AGAIN, the missing border moved. If this were a DTP program, I would think that there is so object hidden behind, or something. Does this new info help at all? Any more ideas???

    THANKS TO YOU ALL (even though I am no closer!)

  4. #14
    New Member
    Join Date
    Apr 2002
    Location
    California
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    It sounds like a glitch in the communication between the printer and computer. If you don't have the option of dealing with drivers and so forth, you might be able to start afresh...

    It's kind of brute force, but if you're willing to do the extra steps, I'd try this: copy the tab to a new file (my favorite way is to right-click on the sheet tab, select Move or Copy, select "(new book)" from the drop-down, click the "Create a Copy" check box, and click OK). Then remove ALL formatting -- select All (ctrl-A), Edit/Clear/Formats.

    Then, one by one, add your formats back in, starting with the borders. Check your print preview. If it's okay, add other formatting (numbers, bold, wrap-text, etc) back in one at a time, checking print preview after each.

    If it works, you can Save As with the original filename. If not, trash the file and come back for an apology for the waste your time...

    Cath

  5. #15
    Board Regular
    Join Date
    Apr 2002
    Posts
    107
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I recently had a similar problem...except one vertical border was not printing. Is this a blank cell? If so, try putting a single space in the cell. That fixed my problem...but why it fixed it I do not know.

  6. #16
    New Member
    Join Date
    May 2002
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks everyone for such great ideas. Yes, I AM REBUILDING THE FILE FROM SCRATCH. This has to be presented at a big meeting. Obviously, there is a systemic problem that defies Excel knowledge. Wahhhh. Thanks for all your ideas. I will be in the office at 7 a.m. on Monday, formatting, formatting, formatting. There are worse things, I am sure! Happy weekend all!

  7. #17

    Join Date
    Apr 2002
    Posts
    15
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You could always take the technical route and use a ruler and pen/pencil to draw the missing line on the printed document.

  8. #18
    New Member
    Join Date
    Feb 2006
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Horizontal and Vertical borders disappear in Print Preview

    I just had the same problem.

    The suggestion above:

    "Does the cell without the border contain an entry nearly as wide as the cell? If so, try making the column a bit wider."

    Worked for me.

    I even made missing horizontal lines reappear by making the row a bit higher.

    Strange but true. I tried many times to recreate the spreadsheet to avoid the problem, but when a simple paste created the problem again, I found the answer in this forum and this thread.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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