Excel gridlines question.

[h-bomb]

I have taken Excel spreadsheet that I didn't create and copied it into a new
document and changed a few things for a new purpose. It looks good on
screen, but when I print lots of the cell borders are missing. I made sure
that print gridlines was turned on. I even went in and formatted the cells
in question manually, by selecting Format Cells and working in the Border
tab.

On another forum, someone suggested I had mixed settings. So, I selected
the entire worksheet, chose the format/cells/borders command and removed all
borders. From page setup dialog, I checked the print gridlines checkbox.
The last part didn't make sense to me. Anyway, when I printed, NONE of the
lines showed up. Argh!! At least I had some gridlines before.

I'm on 10.2.8 using office v.x.

How can I fix this? I just want the lines to print as I see them.

Thank you.

 

[Jim Gordon MVP]

Hi,

Check the Page Setup section on the Sheets tab. Make sure it is not set
to "draft" quality printing.

-Jim

 

[H-bomb]

Thank you for replying, but that wasn't it.

I ended up re-creating the document, but of course I didn't want to do that
which is why I copied and pasted to begin with. Well, I've moved on and now
have what I need, but I sure would like to know what's wrong with the
document I was working with. At this point, I just want to figure it out to
learn what's wrong, but I don't know if I ever will. If you have any other
suggestions, I'll all ears. Maybe somewhere along the way could something
have been corrupted just enough to give me the results I'm getting?

H-bomb

 

[Bob Greenblatt]

Thank you for replying, but that wasn't it.

I ended up re-creating the document, but of course I didn't want to do that
which is why I copied and pasted to begin with. Well, I've moved on and now
have what I need, but I sure would like to know what's wrong with the
document I was working with. At this point, I just want to figure it out to
learn what's wrong, but I don't know if I ever will. If you have any other
suggestions, I'll all ears. Maybe somewhere along the way could something
have been corrupted just enough to give me the results I'm getting?

H-bomb

It probably was not corruption, but the cell's color was probably set to
white instead of automatic. This will override the gridlines.