Highlight the cells you want to restore grid line after removing the colour. On the "Home" tab, click on theme colour and select "no fill" (the icon below the standard colour). Unhighlight the cells. Voila!

On Saturday, September 13, 2008 3:18 PM Alan R wrote:

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.


On Saturday, September 13, 2008 3:21 PM Mike wrote:

Hi,

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

Mike

"Alan R." wrote:


On Saturday, September 13, 2008 3:22 PM Rick Rothstein wrote:

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

--
Rick (MVP - Excel)


On Thursday, October 02, 2008 9:50 AM Rosa5 wrote:

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

"Alan R." wrote:


On Thursday, October 02, 2008 2:49 PM Gord Dibben wrote:

For Alan

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

For Rosa

Not possible.


Gord Dibben MS Excel MVP

wrote:


On Tuesday, October 07, 2008 4:51 AM Rosa5 wrote:

Gord, thanks for the disappointing answer. At least I will stop trying.

"Gord Dibben" wrote: