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

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

Hi Dave,

Yep. Objects on screen. Forgot about those.
And, they were multiple placements of objects on the exact same spot.
Thanks. That's been bugging my reports for months.

MichaelM

"Dave Peterson" wrote:

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