View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Susan Susan is offline
external usenet poster
 
Posts: 1,117
Default Cleaning up the screen

(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