How to remove page break lines in normal view?

N

nomail1983

After I did Print Preview and Close, the normal view of the spreadsheet
now shows the page breaks as dashed lines. How can I remove those
lines from the display?

I am using Office Excel 2003.
 
G

Gazeta

Uzytkownik said:
After I did Print Preview and Close, the normal view of the spreadsheet
now shows the page breaks as dashed lines. How can I remove those
lines from the display?

I am using Office Excel 2003.
view - switch to normal viev
mcg
 
N

nomail1983

Gazeta said:
view - switch to normal viev

That did not work for me. As I noted, I was in normal view to begin
with. But before I posted my question, I did try selecting View >
Normal View. I even tried toggling between Page Break Preview and
Normal View.
 
N

nomail1983

Debra said:
Choose Tools>Options
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.
 
N

nomail1983

I said:
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
:-(.
 

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

Top