I have inserted a page break into my worksheet but it does not respond. The
taskbar says that it is there but it does not show up

Go the Print Preview and see.

Jaleel

"Granite_Plow" wrote:

I have inserted a page break into my worksheet but it does not respond. The
taskbar says that it is there but it does not show up

Are you looking for a dotted line on your sheet where the page break should be?

ToolsOptionsView. Checkmark in "Page Break"


Gord Dibben MS Excel MVP

On Wed, 18 Oct 2006 23:08:01 -0700, Granite_Plow
wrote:

I have inserted a page break into my worksheet but it does not respond. The
taskbar says that it is there but it does not show up

I think Granite_Plow is experiencing my problem (GP, if I am mistaken, please
forgive me for commandeering your thread).

I select a row where I want to add a page break, select Insert - Page
Break. I know it was successfulyl added because the Page Break option has
been replaced with Remove Page Break, but when I print the document, it does
not apply the page break I set.

Besides doing what I did, how do I get this to work?

"Gord Dibben" wrote:

Are you looking for a dotted line on your sheet where the page break should be?

ToolsOptionsView. Checkmark in "Page Break"


Gord Dibben MS Excel MVP

On Wed, 18 Oct 2006 23:08:01 -0700, Granite_Plow
wrote:

I have inserted a page break into my worksheet but it does not respond. The
taskbar says that it is there but it does not show up

If it doesn't apply the pagebreak where you inserted it, where does it break?

What do you see in ViewPageBreak?

What are the settings in FilePage SetupAdjust to or Fit to?

These can override pagebreaks.


Gord Dibben MS Excel MVP


On Tue, 9 Jan 2007 12:12:01 -0800, Big Brother <Big
wrote:

I think Granite_Plow is experiencing my problem (GP, if I am mistaken, please
forgive me for commandeering your thread).

I select a row where I want to add a page break, select Insert - Page
Break. I know it was successfulyl added because the Page Break option has
been replaced with Remove Page Break, but when I print the document, it does
not apply the page break I set.

Besides doing what I did, how do I get this to work?

"Gord Dibben" wrote:

Are you looking for a dotted line on your sheet where the page break should be?

ToolsOptionsView. Checkmark in "Page Break"


Gord Dibben MS Excel MVP

On Wed, 18 Oct 2006 23:08:01 -0700, Granite_Plow
wrote:

I have inserted a page break into my worksheet but it does not respond. The
taskbar says that it is there but it does not show up

It was breaking at the normal end of page.

You hit it, though. I had the page size set to 1 wide by 3 tall. Since it
was only going to be a 2 or 3 page document (with the page breaks), I figured
that it would not be an issue. It apparently was. When I changed the
re-size to be a certain percentage, the page break took effect.

While this sounds like a bug to me, at least I have a workaround.

Thanks for the help.

"Gord Dibben" wrote:

If it doesn't apply the pagebreak where you inserted it, where does it break?

What do you see in ViewPageBreak?

What are the settings in FilePage SetupAdjust to or Fit to?

These can override pagebreaks.


Gord Dibben MS Excel MVP


On Tue, 9 Jan 2007 12:12:01 -0800, Big Brother <Big
wrote:

I think Granite_Plow is experiencing my problem (GP, if I am mistaken, please
forgive me for commandeering your thread).

I select a row where I want to add a page break, select Insert - Page
Break. I know it was successfulyl added because the Page Break option has
been replaced with Remove Page Break, but when I print the document, it does
not apply the page break I set.

Besides doing what I did, how do I get this to work?

"Gord Dibben" wrote:

Are you looking for a dotted line on your sheet where the page break should be?

ToolsOptionsView. Checkmark in "Page Break"


Gord Dibben MS Excel MVP

On Wed, 18 Oct 2006 23:08:01 -0700, Granite_Plow
wrote:

I have inserted a page break into my worksheet but it does not respond. The
taskbar says that it is there but it does not show up

Thanks for the feedback.


Gord

On Wed, 10 Jan 2007 07:35:21 -0800, Big Brother
wrote:

It was breaking at the normal end of page.

You hit it, though. I had the page size set to 1 wide by 3 tall. Since it
was only going to be a 2 or 3 page document (with the page breaks), I figured
that it would not be an issue. It apparently was. When I changed the
re-size to be a certain percentage, the page break took effect.

While this sounds like a bug to me, at least I have a workaround.

Thanks for the help.

"Gord Dibben" wrote:

If it doesn't apply the pagebreak where you inserted it, where does it break?

What do you see in ViewPageBreak?

What are the settings in FilePage SetupAdjust to or Fit to?

These can override pagebreaks.


Gord Dibben MS Excel MVP


On Tue, 9 Jan 2007 12:12:01 -0800, Big Brother <Big
wrote:

I think Granite_Plow is experiencing my problem (GP, if I am mistaken, please
forgive me for commandeering your thread).

I select a row where I want to add a page break, select Insert - Page
Break. I know it was successfulyl added because the Page Break option has
been replaced with Remove Page Break, but when I print the document, it does
not apply the page break I set.

Besides doing what I did, how do I get this to work?

"Gord Dibben" wrote:

Are you looking for a dotted line on your sheet where the page break should be?

ToolsOptionsView. Checkmark in "Page Break"


Gord Dibben MS Excel MVP

On Wed, 18 Oct 2006 23:08:01 -0700, Granite_Plow
wrote:

I have inserted a page break into my worksheet but it does not respond. The
taskbar says that it is there but it does not show up