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

  • Thread starter Thread starter Alan R.
  • Start date Start date
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.
 
Hi,

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

Mike
 
Don't "return it to white"... use either None or No Fill (which of the two
is available).
 
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
 
For Alan

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

For Rosa

Not possible.


Gord Dibben MS Excel MVP
 
Gord, thanks for the disappointing answer. At least I'll stop trying.
 
You must log in or register to reply here.

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

Blank Sheet with Gridlines 11
GRIDLINES 7 FILL COLOR 4
display gridlines with fill color 1
Gridlines not shown in certain cells 2
Remove Pattern Without Affecting Cell Color or Gridlines 8
Gridlines over cell background color. 1
Gridlines 1
How do I change the automatic color default in Excel 2007? 0

Back
Top