Archive of Mr Excel Message Board


Back to Forms in Excel VBA archive index
Back to archive home

Gridlines disappear

Posted by Jeff Shein on October 02, 2000 11:16 AM

I have a few spreadsheets where SOME of the gridlines have disappeared. I can make them all disappear with the Tools\Options\Gridlines menu options, but when I click the checkbox, not all the gridlines return. I do not have borders in any of the cells where this is happening. I can make borders to match (using a light grey)... but I shouldn't have to do that! I've searched this site, and I saw some entries regarding printing of gridlines... unfortunately, that isn't the problem here. It's strictly a display concern.

Has anyone experienced this problem?

Thanks


Re: Gridlines disappear

Posted by Ben on October 03, 2000 7:09 AM
It's possible that the cells that don't show gridlines have been shaded white, hiding the gridlines. Either select the just the cells in question or all of the cells on the worksheet and go to Format > Cells > Pattern and click on No Color. Then hit OK.

It's also possible that the cells have white borders added. Again, select the cells, go to Format > Cells > Border and then click None.

I'm reasonably confident that one of those methods will solve your problem.

-Ben


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.