View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Force Page Break in Excel?

One way:

Insert/Page Break

No widow/orphan protection, per se, but in Page Setup you can set
scaling to Fit to x pages wide by y tall.


the In article ,
NicoleS wrote:

Is there a way to force a page break in Excel?
(like in word: you can use control+enter)

Sometimes I'd like sections of my pages to stay together when printing.

Along that thought - is there a way to do a "widow" or "orphan" protect that
just one line of a section doesn't bump to the next page?

Thanks!