Page break says it has been inserted but does not respond

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?

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


Gord Dibben MS Excel MVP
 
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
 
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.
 
Back
Top