Page break says it has been inserted but does not respond

[Granite_Plow]

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

 

[Jaleel]

Go the Print Preview and see.

Jaleel

 

[Gord Dibben]

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

Tools>Options>View. Checkmark in "Page Break"


Gord Dibben MS Excel MVP

 

[Gord Dibben]

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

What do you see in View>PageBreak?

What are the settings in File>Page Setup>Adjust 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

 

[Gord Dibben]

Thanks for the feedback.


Gord

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.