View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
[email protected] nomail1983@hotmail.com is offline
external usenet poster
 
Posts: 40
Default How to remove page break lines in normal view?

I wrote:
Debra Dalgleish wrote:
Choose ToolsOptions
On the View tab, remove the check mark from 'Page Breaks'
Click OK


Bingo! That works. Thanks. It also works to close and reopen the
workbook; but that is less desirable.


Hmm, it appears that the Options View Page Breaks option is not set
when the workbook is opened, even if it was set when the workbook was
last saved. The option gets set automagically after I do Print Preview
:-(.