How do I restore cell gridlines lost after coloring a cell?

A

Alan R.

While working on my Excel worksheet I sometimes color cells. When the cell
is returned to white the gridlines for those specific cells are gone. How
can I restore them?

Alan R.
 
M

Mike H

Hi,

White is a colour and it hides the gridlines. When you remove the colour
select 'No Fill' and not white.

Mike
 
R

Rick Rothstein

Don't "return it to white"... use either None or No Fill (which of the two
is available).
 
R

Rosa59

I have been battling a similar problem that I would like to maintain the
gridlines when cells are colored. I don't like adding borders. Is it possible?
Rosa
 
G

Gord Dibben

For Alan

Don't color the cells white. Set them to no color or automatic.

For Rosa

Not possible.


Gord Dibben MS Excel MVP
 

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

Remove Pattern Without Affecting Cell Color or Gridlines 8
Gridlines disappear 1
How do I mark certains cells with gridlines? 3
some missing gridlines 5
Restoring Excel gridlines after removing background shading? 2
Hiding cells based on the value in another cell 3
How do I change the automatic color default in Excel 2007? 0
How do you show/hide individual cell gridlines in Excel 2007? 2

Top