Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Page Break Ghost
I have a situation where I cannot insert a page break - I go to Insert Page
Break and there is no page break inserted. What could be happening? This spreadsheet has some text boxes in it. Other than that, it's a basic spredsheet. Thank you, Karen |
#2
|
|||
|
|||
Manual page breaks are turned off if you've set "fit to" under File, Page
Setup, Page instead of "adjust to". -- Jim "Karen" wrote in message ... |I have a situation where I cannot insert a page break - I go to Insert Page | Break and there is no page break inserted. What could be happening? This | spreadsheet has some text boxes in it. Other than that, it's a basic | spredsheet. | | Thank you, Karen |
#3
|
|||
|
|||
Check your page setup. Is it set at "Fit to..."? This is often the cause.
Change to "Adjust to...." then try to insert a page break. "Karen" wrote: I have a situation where I cannot insert a page break - I go to Insert Page Break and there is no page break inserted. What could be happening? This spreadsheet has some text boxes in it. Other than that, it's a basic spredsheet. Thank you, Karen |
#4
|
|||
|
|||
I think xl2002 changed this behavior.
I added 3 manual page breaks to a test worksheet. I did file|page setup|Page tab Fit to: 1 page(s) wide by (empty) tall. And xl2003 still respected those manual page breaks. (But xl2002 did the same, IIRC.) (I thought that this was a very nice enhancement.) Jim Rech wrote: Manual page breaks are turned off if you've set "fit to" under File, Page Setup, Page instead of "adjust to". -- Jim "Karen" wrote in message ... |I have a situation where I cannot insert a page break - I go to Insert Page | Break and there is no page break inserted. What could be happening? This | spreadsheet has some text boxes in it. Other than that, it's a basic | spredsheet. | | Thank you, Karen -- Dave Peterson |
#5
|
|||
|
|||
Fit to: 1 page(s) wide by (empty) tall.
I agree that the above will show horizontal page breaks but I think she probably does not have the tall setting empty. Any number there causes the symptom I believe. -- Jim "Dave Peterson" wrote in message ... |I think xl2002 changed this behavior. | | I added 3 manual page breaks to a test worksheet. | I did file|page setup|Page tab | Fit to: 1 page(s) wide by (empty) tall. | | And xl2003 still respected those manual page breaks. (But xl2002 did the same, | IIRC.) | | (I thought that this was a very nice enhancement.) | | Jim Rech wrote: | | Manual page breaks are turned off if you've set "fit to" under File, Page | Setup, Page instead of "adjust to". | | -- | Jim | "Karen" wrote in message | ... | |I have a situation where I cannot insert a page break - I go to Insert | Page | | Break and there is no page break inserted. What could be happening? This | | spreadsheet has some text boxes in it. Other than that, it's a basic | | spredsheet. | | | | Thank you, Karen | | -- | | Dave Peterson |
#6
|
|||
|
|||
You are correct, sir!
Jim Rech wrote: Fit to: 1 page(s) wide by (empty) tall. I agree that the above will show horizontal page breaks but I think she probably does not have the tall setting empty. Any number there causes the symptom I believe. -- Jim "Dave Peterson" wrote in message ... |I think xl2002 changed this behavior. | | I added 3 manual page breaks to a test worksheet. | I did file|page setup|Page tab | Fit to: 1 page(s) wide by (empty) tall. | | And xl2003 still respected those manual page breaks. (But xl2002 did the same, | IIRC.) | | (I thought that this was a very nice enhancement.) | | Jim Rech wrote: | | Manual page breaks are turned off if you've set "fit to" under File, Page | Setup, Page instead of "adjust to". | | -- | Jim | "Karen" wrote in message | ... | |I have a situation where I cannot insert a page break - I go to Insert | Page | | Break and there is no page break inserted. What could be happening? This | | spreadsheet has some text boxes in it. Other than that, it's a basic | | spredsheet. | | | | Thank you, Karen | | -- | | Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Page scaling & Page break preview prob | Excel Discussion (Misc queries) | |||
page break preview | Excel Discussion (Misc queries) | |||
How do I change "PAGE 1" characteristics in page break? | Excel Discussion (Misc queries) | |||
adding a new page break to an existing page break | Excel Discussion (Misc queries) | |||
content does not stay in page break | Excel Worksheet Functions |