Keep rows on same page in Excel

S

SWeyer

Is there a way to tag rows in Excel so that they stay together (same page)
when printing? I have sub heading rows in a spreadsheet that I would like to
make sure stay with the subsequent rows when I print it, instead of leaving
some one one page and the others on the next.
 
G

Gord Dibben

If same sub-headings for each page, use File>Page Setup>Sheet>Rows to repeat
at Top.

Select the top 4 rows and OK.

If sub-headings are different for separate sections(pages) then I would
suggest setting manual Page Breaks.


Gord Dibben Excel MVP
 
D

Dave Peterson

I bet you're asking if excel has anything similar to MSWords "keep with next"
and "keep lines together".

It doesn't.
 
C

CyberTaz

If I understand the issue, you may be able to get what you want by using Page
Break Preview. The blue lines can be dragged to have the page breaks fall in
more appropriate places.

Hope this is useful |:>)
 
Top