I am working in Excel XP and I have a large sheet that I work on all the time
and now out of know were the page break ----- doted lines do not show. All I
had to do to make them show up was go to File/Page Setup/Sheet/OK but that
does not work. I looked in TOOLS/OPTIONS/Window Options to see if there was a
check mark in Page breaks and there is. The break mark"-----" shows up in all
other workbooks in Excel. How can I get the page break marks "-----" to show
up.

Do you have your sheet set to "Fit to 1 page(s) wide by 1 tall" in
Tools/Options/Page/Scaling?


In article ,
"Jason" wrote:

I am working in Excel XP and I have a large sheet that I work on all the time
and now out of know were the page break ----- doted lines do not show. All I
had to do to make them show up was go to File/Page Setup/Sheet/OK but that
does not work. I looked in TOOLS/OPTIONS/Window Options to see if there was a
check mark in Page breaks and there is. The break mark"-----" shows up in all
other workbooks in Excel. How can I get the page break marks "-----" to show
up.

YES

"JE McGimpsey" wrote:

Do you have your sheet set to "Fit to 1 page(s) wide by 1 tall" in
Tools/Options/Page/Scaling?


In article ,
"Jason" wrote:

I am working in Excel XP and I have a large sheet that I work on all the time
and now out of know were the page break ----- doted lines do not show. All I
had to do to make them show up was go to File/Page Setup/Sheet/OK but that
does not work. I looked in TOOLS/OPTIONS/Window Options to see if there was a
check mark in Page breaks and there is. The break mark"-----" shows up in all
other workbooks in Excel. How can I get the page break marks "-----" to show
up.

In article ,
"Jason" wrote:

YES

That's the one that bites me every so often. Hard to have page breaks
when there's only one page...

NO, but it is 12pg. long Not one

"JE McGimpsey" wrote:

In article ,
"Jason" wrote:

YES

That's the one that bites me every so often. Hard to have page breaks
when there's only one page...

JE asked if you had it set for: "Fit to 1 page(s) wide by 1 tall"

you answered Yes. Did you mean that?

Maybe you want: "Fit to 1 page(s) wide by (leave empty) tall"



Jason wrote:

NO, but it is 12pg. long Not one

"JE McGimpsey" wrote:

In article ,
"Jason" wrote:

YES

That's the one that bites me every so often. Hard to have page breaks
when there's only one page...


--

Dave Peterson

If you set Page Setup to "1 page wide by 1 tall", then it's *one* page...


In article ,
"Jason" wrote:

NO, but it is 12pg. long Not one

and in XP ther is no Page/Scalling option I did it in the Page Setup

"JE McGimpsey" wrote:

In article ,
"Jason" wrote:

YES

That's the one that bites me every so often. Hard to have page breaks
when there's only one page...