View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_5_] Dave Peterson[_5_] is offline
external usenet poster
 
Posts: 1,758
Default Some formatting 'lines' will not go away

My first guess is that the lines are gridlines (different from Borders).

Tools|Options|View tab|check/uncheck Gridlines
will show/hide them on the screen.

File|page setup|sheet tab|check/uncheck Gridlines
will print/not print gridlines.

(I don't like the gridlines. I turn them off and use borders where I want
them.)

My next guess is that maybe the lines are objects from the drawing toolbar.
edit|goto|special|click Objects
to see if they get selected.


Michael Miller wrote:

This is not exactly programming, but there was no formatting nor general
category.

I have many cells with lines and boxes around them.
When I try to elim some vertical lines, via the lines drop down or the
formatting dialog/borders, the lines do not go away and even the borders
dialog does not show them as being there.

I have highlighted an entire column and I have highlighted two cells, which
had a vertical line between them. The border formatting does not show them.
And, the vertical lines don't go down thru the entire sheet, at the end of
contents, a line may proceed down some 3-5 rows, and they print also.

Anyone know how to find these lines so I can unformat them?
--
MichaelM


--

Dave Peterson