View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier Roger Govier is offline
external usenet poster
 
Posts: 2,886
Default Grey pattern loses gridlines

Hi

In all versions of Excel, if adopt a fill colour for the cells, then the
gridlines are lost.
You have to add cell borders in such cases.
If you want to restore the gridlines, set the fill colour to No Fill.

--
Regards

Roger Govier


"Scott" wrote in message
...
I am using Excel 2007 and do not understand why the gridlines disappear
when I set the cells in grey pattern. Can someone advise me how to
restore the gridlines in a quicker way. Currently I have to manually
add the outlines back.

Thanks,

Scott