Restoring the light gray cell borders...

J

John Wirt

For some reason I have not been able to determine, The light gray border
that surrounds each cell in a new worksheet turns white. SO , it looks like
the cell has "disappeared." Of course, this is just a visual issue, since
the cell still exists and works fine.

My question is, how can I restore the border. I have found that it is
possible to reestablish a facsimile of the original borders using the
Format/Cell/Borders menu options and setting color to the lightest gray on
the palette but this seems like a crude method. There must be a more direct
method.

What is it?

John Wirt
 
G

Gord Dibben

John

Tools>Options>View. Make sure Gridlines is checked and Gridlines color is set
to Automatic.

Note: if cells' background color has been set to White you won't see the
Gridlines. Default background color is "no color".

Gord Dibben Excel MVP XL2002
 

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

Excel: Remove color background from cells, restore grid. 2
In VBA Excel, how can I restore individual cells? 2
Print cell borders with special 'skin' 0
Thin white border appears between cells 2
Cell Border will not Hide 4
conditionally formatting 3
automated addition of a picture to a cell comment 2
Darken color of Active Cell Border 1

Top