Some formatting 'lines' will not go away

[Guest]

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?

 

[Dave Peterson]

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.

 

[Guest]

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