I have noticed that when I edit data in multiple cells by deleting, and then
repair the background color of those cells, the "virtual" lines around the
cells I'v just repainted disappear. These aren't lines that I've defined as
belonging to the cells, these are cells that started out with no lines around
them beyond those provided on an empty WS. As I have made multiple tweaks of
this nature, the section where I am using background color is beginning to
look as though it has caught some exotic skin disease.

How do I get those virtual lines back?
--
Dave
Temping with Staffmark
in Rock Hill, SC

(if i understand you correctly)............ whenever you insert a
color into a cell, those virtual gridmarks are no longer visible.
that's normal.

try this:
open a new workbook.
highlight a range of cells in the middle
add a color to them
move elsewhere

the gridlines are visible on the non-shaded cells, but NOT on the
shaded cells. the only way to make gridlines on the shaded cells is
to insert a border of a slightly darker color - but they will be
visible when you print (if that's ok).
hope this helps
susan



On May 11, 8:55 am, Dave Birley
wrote:
I have noticed that when I edit data in multiple cells by deleting, and then
repair the background color of those cells, the "virtual" lines around the
cells I'v just repainted disappear. These aren't lines that I've defined as
belonging to the cells, these are cells that started out with no lines around
them beyond those provided on an empty WS. As I have made multiple tweaks of
this nature, the section where I am using background color is beginning to
look as though it has caught some exotic skin disease.

How do I get those virtual lines back?
--
Dave
Temping with Staffmark
in Rock Hill, SC

Hmmmm. I did the experiment you suggested, and it did what you said it would
do. However I have a number of ranges in my WS where there is background
color, and the virtual gridlines are visible. If I copy a chumk of these and
paste them into a new WS, the virtual gridlines show on the section I paste.
OTOH, if I edit them in place by deleting (golor returns to white) and then
click the Fill COlor icon, gridlines disappear.

It isn't a biggie, just a bit of OCD on my part, liking things to look
consistent.
--
Dave
Temping with Staffmark
in Rock Hill, SC


"Susan" wrote:

(if i understand you correctly)............ whenever you insert a
color into a cell, those virtual gridmarks are no longer visible.
that's normal.

try this:
open a new workbook.
highlight a range of cells in the middle
add a color to them
move elsewhere

the gridlines are visible on the non-shaded cells, but NOT on the
shaded cells. the only way to make gridlines on the shaded cells is
to insert a border of a slightly darker color - but they will be
visible when you print (if that's ok).
hope this helps
susan



On May 11, 8:55 am, Dave Birley
wrote:
I have noticed that when I edit data in multiple cells by deleting, and then
repair the background color of those cells, the "virtual" lines around the
cells I'v just repainted disappear. These aren't lines that I've defined as
belonging to the cells, these are cells that started out with no lines around
them beyond those provided on an empty WS. As I have made multiple tweaks of
this nature, the section where I am using background color is beginning to
look as though it has caught some exotic skin disease.

How do I get those virtual lines back?
--
Dave
Temping with Staffmark
in Rock Hill, SC

well, us geeky-excel-macro-type-people tend to be a little OCD, don't
we?
if we weren't perfectionists with our spreadsheets, we wouldn't be
interested in macros!
ha ha
:)
susan


On May 11, 9:43 am, Dave Birley
wrote:
Hmmmm. I did the experiment you suggested, and it did what you said it would
do. However I have a number of ranges in my WS where there is background
color, and the virtual gridlines are visible. If I copy a chumk of these and
paste them into a new WS, the virtual gridlines show on the section I paste.
OTOH, if I edit them in place by deleting (golor returns to white) and then
click the Fill COlor icon, gridlines disappear.

It isn't a biggie, just a bit of OCD on my part, liking things to look
consistent.
--
Dave
Temping with Staffmark
in Rock Hill, SC



"Susan" wrote:
(if i understand you correctly)............ whenever you insert a
color into a cell, those virtual gridmarks are no longer visible.
that's normal.

try this:
open a new workbook.
highlight a range of cells in the middle
add a color to them
move elsewhere

the gridlines are visible on the non-shaded cells, but NOT on the
shaded cells. the only way to make gridlines on the shaded cells is
to insert a border of a slightly darker color - but they will be
visible when you print (if that's ok).
hope this helps
susan

On May 11, 8:55 am, Dave Birley
wrote:
I have noticed that when I edit data in multiple cells by deleting, and then
repair the background color of those cells, the "virtual" lines around the
cells I'v just repainted disappear. These aren't lines that I've defined as
belonging to the cells, these are cells that started out with no lines around
them beyond those provided on an empty WS. As I have made multiple tweaks of
this nature, the section where I am using background color is beginning to
look as though it has caught some exotic skin disease.

How do I get those virtual lines back?
--
Dave
Temping with Staffmark
in Rock Hill, SC- Hide quoted text -

- Show quoted text -