Gridlines not showing on screen


G

Guest

I have an employee that is having problems showing gridlines. Everytime she creates a new worksheet it does not show the gridlines even though the show gridlines box is checked. If we change the gridline color from automatic it will show them only on that worksheet but will not show it on a new one. Any suggestions?
 
Ad

Advertisements

M

Mark Henri

I have an employee that is having problems showing gridlines. Everytime
she creates a new worksheet it does not show the gridlines even though the
show gridlines box is checked. If we change the gridline color from
automatic it will show them only on that worksheet but will not show it on
a new one. Any suggestions?

I'm assuming that you mean the gridlines on the screen. Whenever there's a
rendering problem (to the screen as well as the printer), the printer
driver or the video drivers are suspect. Try installing a generic driver
like an HP Deskjet 870 and see if you still have the problem. Get the
latest video driver from the manufacturer and try it also.

Run through these standard troubleshooting steps also just to further rule
out issues--

http://www.markhenri.com/excel/stdtroubleshooting.html
 
D

David McRitchie

I think it has been reported that accessibility options might
affect the screen display.

Control Panel, Accessibility Options. Display tab, clear the Use High Contrast check box, OK


You will not see gridlines with draft quality. I have a page on
Gridlines and Borders
http://www.mvps.org/dmcritchie/excel/gridline.htm
 
G

Guest

I have tried all of the suggestions from both Mark and David but yet nothing worked. What I don't understand is why the gridlines will show if the background is changed or if the color of the gridlines is changed. I am finding out we have a few other pcs doing the same thing. They are newer Dell models so, I guess its back to the drawing board. Any other suggestions?
 
D

David McRitchie

Perhaps this user has her own sheet.xlt and book.xlt templates
that have cell interior (pattern) color set to white instead of automatic.
But if you have this then gridlines should be wiped out on both
display and print. Okay perhaps you have Print B&W

Borders and interior colors wipe out gridlines. Sounds like the
Borders are set to white in the sheet.xlt template and the
print is set to B&W so that you see borders as black
even though they are white..
File, Page Setup. Sheet, Print B&W


cscasto said:
I have tried all of the suggestions from both Mark and David but yet nothing worked. What I don't understand is why the gridlines
will show if the background is changed or if the color of the gridlines is changed. I am finding out we have a few other pcs doing
the same thing. They are newer Dell models so, I guess its back to the drawing board. Any other suggestions?
 
Ad

Advertisements

M

Mark Henri

I have tried all of the suggestions from both Mark and David but yet
nothing worked. What I don't understand is why the gridlines will show if
the background is changed or if the color of the gridlines is changed. I
am finding out we have a few other pcs doing the same thing. They are
newer Dell models so, I guess its back to the drawing board. Any other
suggestions?

So it still happens when Excel is in safe mode and the OS is in safe boot?
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top