software

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:
gt;
gt; The dotted line showing where Excel has put in page breaks do not normally
gt; show and the default for a new sheet under Tools and Options is for them not
gt; to show.
gt;
gt; Question 1
gt; Sometimes the page breaks are turned on automatically and there does not
gt; seem to be a reason for this.
gt;
gt; Question 2
gt; I had originally thought that there was no way to see where a print area has
gt; been set unless you go into Page Break preview but when I came to do it just
gt; now both in XP and 2003, I find I can see it in Normal view and also see that
gt; Show Page Breaks has been automatically selected in Tools and Options. Why
gt; have I never seen this before?!
gt;
gt; Thanks

--

Dave Peterson

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

quot;Dave Petersonquot; wrote:

gt; #1. I've only seen them when I turn them on (tools|options|view tab) or ran a
gt; macro that turned them on. Or run File|print preview (or print). Any of those
gt; things will show those dotted lines.
gt;
gt; #2. I don't know why you never saw it before, but try staying in normal view
gt; and changing the zoom level to 40% or smaller. (another way to see the page
gt; layout)
gt;
gt; Phippsy wrote:
gt; gt;
gt; gt; The dotted line showing where Excel has put in page breaks do not normally
gt; gt; show and the default for a new sheet under Tools and Options is for them not
gt; gt; to show.
gt; gt;
gt; gt; Question 1
gt; gt; Sometimes the page breaks are turned on automatically and there does not
gt; gt; seem to be a reason for this.
gt; gt;
gt; gt; Question 2
gt; gt; I had originally thought that there was no way to see where a print area has
gt; gt; been set unless you go into Page Break preview but when I came to do it just
gt; gt; now both in XP and 2003, I find I can see it in Normal view and also see that
gt; gt; Show Page Breaks has been automatically selected in Tools and Options. Why
gt; gt; have I never seen this before?!
gt; gt;
gt; gt; Thanks
gt;
gt; --
gt;
gt; Dave Peterson
gt;

Have you been to LensCrafters lately lt;vbggt;.

They've been there as long as I can recall.
Phippsy wrote:
gt;
gt; Thanks for this but still not sure if I understand why I have never seen them
gt; before and now I can.
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; #1. I've only seen them when I turn them on (tools|options|view tab) or ran a
gt; gt; macro that turned them on. Or run File|print preview (or print). Any of those
gt; gt; things will show those dotted lines.
gt; gt;
gt; gt; #2. I don't know why you never saw it before, but try staying in normal view
gt; gt; and changing the zoom level to 40% or smaller. (another way to see the page
gt; gt; layout)
gt; gt;
gt; gt; Phippsy wrote:
gt; gt; gt;
gt; gt; gt; The dotted line showing where Excel has put in page breaks do not normally
gt; gt; gt; show and the default for a new sheet under Tools and Options is for them not
gt; gt; gt; to show.
gt; gt; gt;
gt; gt; gt; Question 1
gt; gt; gt; Sometimes the page breaks are turned on automatically and there does not
gt; gt; gt; seem to be a reason for this.
gt; gt; gt;
gt; gt; gt; Question 2
gt; gt; gt; I had originally thought that there was no way to see where a print area has
gt; gt; gt; been set unless you go into Page Break preview but when I came to do it just
gt; gt; gt; now both in XP and 2003, I find I can see it in Normal view and also see that
gt; gt; gt; Show Page Breaks has been automatically selected in Tools and Options. Why
gt; gt; gt; have I never seen this before?!
gt; gt; gt;
gt; gt; gt; Thanks
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson

Turning the screen on helped as well!!!

quot;Dave Petersonquot; wrote:

gt; Have you been to LensCrafters lately lt;vbggt;.
gt;
gt; They've been there as long as I can recall.
gt;
gt;
gt;
gt; Phippsy wrote:
gt; gt;
gt; gt; Thanks for this but still not sure if I understand why I have never seen them
gt; gt; before and now I can.
gt; gt;
gt; gt; quot;Dave Petersonquot; wrote:
gt; gt;
gt; gt; gt; #1. I've only seen them when I turn them on (tools|options|view tab) or ran a
gt; gt; gt; macro that turned them on. Or run File|print preview (or print). Any of those
gt; gt; gt; things will show those dotted lines.
gt; gt; gt;
gt; gt; gt; #2. I don't know why you never saw it before, but try staying in normal view
gt; gt; gt; and changing the zoom level to 40% or smaller. (another way to see the page
gt; gt; gt; layout)
gt; gt; gt;
gt; gt; gt; Phippsy wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; The dotted line showing where Excel has put in page breaks do not normally
gt; gt; gt; gt; show and the default for a new sheet under Tools and Options is for them not
gt; gt; gt; gt; to show.
gt; gt; gt; gt;
gt; gt; gt; gt; Question 1
gt; gt; gt; gt; Sometimes the page breaks are turned on automatically and there does not
gt; gt; gt; gt; seem to be a reason for this.
gt; gt; gt; gt;
gt; gt; gt; gt; Question 2
gt; gt; gt; gt; I had originally thought that there was no way to see where a print area has
gt; gt; gt; gt; been set unless you go into Page Break preview but when I came to do it just
gt; gt; gt; gt; now both in XP and 2003, I find I can see it in Normal view and also see that
gt; gt; gt; gt; Show Page Breaks has been automatically selected in Tools and Options. Why
gt; gt; gt; gt; have I never seen this before?!
gt; gt; gt; gt;
gt; gt; gt; gt; Thanks
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt;
gt; gt; gt; Dave Peterson
gt; gt; gt;
gt;
gt; --
gt;
gt; Dave Peterson
gt;