Grid lines disappeared !

[Stuart Grant]

I have a moderately large workbook with about 15 worksheets and quite a few
named ranges.

Now I find the grid lines have disappeared from one range nine columns wide
and 48 rows deep. Under Tools-Options "Show grid lines" is checked on all
sheets and I do not recall ever having this unchecked.

How can this happen just from one range, not the sheet ?

Stuart

 

[Guest]

Grid lines will vanish from cells which have been assigned a background colour.

 

[Mickey Mouse]

Grid lines will vanish from cells which have been assigned a background
colour.
--
Gary's Student


Mickey

 

[Stuart Grant]

Mickey
Many thanks. I had never - knowingly - selected a background color for the
range but I highlighted it, selected Format/Font. It did not show any color
selected but I clicked No Color/OK and Bingo ! The grid lines reappeared.
Many thanks.
Stuart