Force Page Break in Excel?

N

NicoleS

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

JE McGimpsey

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 <[email protected]>,
 
K

Kevin B

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...
 
K

Kevin B

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top