View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Phippsy
 
Posts: n/a
Default view page breaks

The dotted line showing where Excel has put in page breaks do not normally
show and the default for a new sheet under Tools and Options is for them not
to show.

Question 1
Sometimes the page breaks are turned on automatically and there does not
seem to be a reason for this.

Question 2
I had originally thought that there was no way to see where a print area has
been set unless you go into Page Break preview but when I came to do it just
now both in XP and 2003, I find I can see it in Normal view and also see that
Show Page Breaks has been automatically selected in Tools and Options. Why
have I never seen this before?!

Thanks