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

#1. I've only seen them when I turn them on (tools|options|view tab) or ran a
macro that turned them on. Or run File|print preview (or print). Any of those
things will show those dotted lines.

#2. I don't know why you never saw it before, but try staying in normal view
and changing the zoom level to 40% or smaller. (another way to see the page
layout)

Phippsy wrote:
>
> 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

--

Dave Peterson

Thanks for this but still not sure if I understand why I have never seen them
before and now I can.

"Dave Peterson" wrote:

> #1. I've only seen them when I turn them on (tools|options|view tab) or ran a
> macro that turned them on. Or run File|print preview (or print). Any of those
> things will show those dotted lines.
>
> #2. I don't know why you never saw it before, but try staying in normal view
> and changing the zoom level to 40% or smaller. (another way to see the page
> layout)
>
> Phippsy wrote:
> >
> > 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
>
> --
>
> Dave Peterson
>

Have you been to LensCrafters lately <vbg>.

They've been there as long as I can recall.



Phippsy wrote:
>
> Thanks for this but still not sure if I understand why I have never seen them
> before and now I can.
>
> "Dave Peterson" wrote:
>
> > #1. I've only seen them when I turn them on (tools|options|view tab) or ran a
> > macro that turned them on. Or run File|print preview (or print). Any of those
> > things will show those dotted lines.
> >
> > #2. I don't know why you never saw it before, but try staying in normal view
> > and changing the zoom level to 40% or smaller. (another way to see the page
> > layout)
> >
> > Phippsy wrote:
> > >
> > > 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
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson

Turning the screen on helped as well!!!

"Dave Peterson" wrote:

> Have you been to LensCrafters lately <vbg>.
>
> They've been there as long as I can recall.
>
>
>
> Phippsy wrote:
> >
> > Thanks for this but still not sure if I understand why I have never seen them
> > before and now I can.
> >
> > "Dave Peterson" wrote:
> >
> > > #1. I've only seen them when I turn them on (tools|options|view tab) or ran a
> > > macro that turned them on. Or run File|print preview (or print). Any of those
> > > things will show those dotted lines.
> > >
> > > #2. I don't know why you never saw it before, but try staying in normal view
> > > and changing the zoom level to 40% or smaller. (another way to see the page
> > > layout)
> > >
> > > Phippsy wrote:
> > > >
> > > > 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
> > >
> > > --
> > >
> > > Dave Peterson
> > >
>
> --
>
> Dave Peterson
>