Grey pattern loses gridlines

[Scott]

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

 

[Roger Govier]

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.

 

[Scott]

Roger,

You are quite right that Microsoft believes this is a right feature for the
customers or ignores the customer's need. Do you find something odd like
this? Is there any difficulties in doing it in terms of programming we may
not know from a point of user? I strongly believe that the gridlines are
lost with fill colour is a long term shortcoming of Excel and is the
weakness of this program that Microsoft seems not to know it.

Scott

 

[Roger Govier]

Hi Scott,

Is there any difficulties in doing it in terms of programming we may
not know from a point of user?

I have no idea. I, like practically all of the respondents in these
NG's, am not a Microsoft employee.

Selecting the range of cells and applying a border with the border icon,
isn't too difficult a task.

If you are wanting the same type of border as the standard gridline,
then on the Home tab, click the Border icon and More Borders>select
colour>pale blue>thin line>click Outline>Click Inside>OK

 

[Bob I]

The feature hasn't changed, it works the same as previous versions, and
apparently was not considered an important must change feature by the
users whose input was taken. Why is that you place such a high priority