Page Breaks
 

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...

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...

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

Yes I ment it, I have over 12 pg. even thoe it is set at 1 BY 1 there is to
much info to fit on just one page. I am looking for the Page Break Lines
"-----" to show on the srceen.

"Dave Peterson" wrote:

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

Jason

I'll try one time. JE may not be back to this post<g

Uncheck the "Fit to 1 page(s) by 1 tall" to see page breaks.

No matter what the size of your print range, if you have "Fit to 1 page by 1
page" checked, Excel will fit it all on one page.


Gord Dibben Excel MVP

On Tue, 22 Mar 2005 16:15:03 -0800, "Jason"
wrote:

Yes I ment it, I have over 12 pg. even thoe it is set at 1 BY 1 there is to
much info to fit on just one page. I am looking for the Page Break Lines
"-----" to show on the srceen.

"Dave Peterson" wrote:

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