removing dotted lines in Excel 2010

**Davidns** · 07-23-2012, 02:07 AM

When I set a print area, dotted lines appear, although they don't seem related to the print area I set. In any case, even when I clear the print area, the lines remain. How do I remove them? Thanks!

**npamcpp** · 07-23-2012, 02:32 AM

That sounds unusual. Does that happen in just one file or all? Do you have the latest Service Pack installed? Is your printer driver up to date? Can you post a sample file that shows the behaviour?

**TMS** · 07-23-2012, 02:33 AM

Vertical? Horizontal? Are they the Page Break indicators?

Regards, TMS

**Davidns** · 07-23-2012, 02:33 AM

Latest service pack is installed, drivers up to date, etc. I just discovered that when I close the file, then reopen it, the lines are gone. As you say, very strange.

**TMS** · 07-23-2012, 03:11 AM

If you do a Print Preview, what do you see? How many pages? Where do they split?

**Davidns** · 07-23-2012, 04:00 AM

I don't see them in print preview. What happens is that as soon as I choose a selection to print, then go to print and choose print selection, vertical and horizontal lines appear in the spreadsheet, but are outside of the print area. And, again, if I close the file, then reopen it, the lines are gone.

**TMS** · 07-23-2012, 04:25 AM

If you press Ctrl-End, which cell is selected? Is it beyond the print area?

To reiterate an earlier question, is it just this workbook/worksheet? And the request; please post a sample workbook that exhibits the problem. And maybe a screen print of what you're seeing.