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
|