Some formatting 'lines' will not go away

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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.
 
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
 
Back
Top