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

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

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" wrote in message
...
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

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 Bordersselect
colourpale bluethin lineclick OutlineClick InsideOK
--
Regards

Roger Govier


"Scott" wrote in message
...
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" wrote in message
...
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

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
on something that has an answer?

Scott wrote:

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" wrote in message
...

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