How to remove dashed page lines after using print preview

S

SmellsFishy

After I close the print preview window in excel, the spreadsheet displays
dashed lines where page breaks occur. I have view set to normal, not page
break preview, and no print area defined. Convenient for formatting a
printout, but distracting otherwise. How do I get rid of them?
 
J

Jim Cone

If you have an Excel version with a toolbar then...
Tools | Options | View (tab) and uncheck "Page breaks"
--
Jim Cone
Portland, Oregon USA


"SmellsFishy"
<[email protected]>
wrote in message
After I close the print preview window in excel, the spreadsheet displays
dashed lines where page breaks occur. I have view set to normal, not page
break preview, and no print area defined. Convenient for formatting a
printout, but distracting otherwise. How do I get rid of them?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

dashed line after print preview 6
How to remove page break lines in normal view? 5
PRINTING IN FILTERED AREA 4
default page breaks in Excel 2007 0
print preview is grey'd out... 0
Getting a page break to take 0
Print Preview in 2007 0
Excel 2007, Page Break Preview - something wierd 0

Top