Keep rows on same page in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
I bet you're asking if excel has anything similar to MSWords "keep with next"
and "keep lines together".

It doesn't.
 
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 |:>)
 
You must log in or register to reply here.

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

Similar Threads

Keeping bottom rows on page one 1
Page break dosen't break 4
Page Breaks- Printing selected rows on same page 1
Keep Row on one page 1
same heading on each page while printing 1
How to auto keep group of rows together and avoid a page break 2
Setting Page Setup 3
Row 1 HEADERS on EVERY printed page 2

Back
Top