This is a “who cares” question that’s been bothering me ever since I started using Excel 2007. Every time I start drawing straight lines using the “line drawing” tool, Excel likes to scatter black dots around on my worksheet in unpredictable patterns that looks like the intersection points of a grid. I have the grid suppressed, so I don’t think it has anything to do with that. No lines are drawn to connect the dots. Actually they are pretty easy to erase except they get scattered around in various places and quantities and are a nuisance to delete. Curiously, the number of dots shown can be as few as one or as many as it takes to fill up most of the worksheet. Or I might see a few here and a few there for no obvious purpose.
What is the purpose of the dots and how can I suppress them?
Sid