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 4
How to remove page break lines in normal view? 5
PRINTING IN FILTERED AREA 4
removing dotted lines denoting page breaks 2
Page Breaks 1
Why does my print area suddenly besome minute in the page preview 1
Print Preview Dotted Lines 1
Excel cuts off bottom of page in Print Preview 2

Top