View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default Force Page Break in Excel?

In the second paragraph I meant to say that you can drag the blue dash break
lines either horizontally or vertically to adjust a page break.

I'd better eat some lunch, apparently I'm in dire need of some protein.
--
Kevin Backmann


"Kevin B" wrote:

While there isn't a widow/orphan control feature in Excel you can click VIEW
in the menu and select PAGE BREAK PREVIEW to review where breaks are
occurring in your print range.

You can the blue dask break lines horizontally/vertically to adjust a page
break. Between this view, adjusting the margin settings and using the
SCALING feature in the PAGE SETUP dialog box should give you all the control
you need to adjust the page breaks to your liking.

Hope this helps...
--
Kevin Backmann


"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!