View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Page break says it has been inserted but does not respond

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