Excel equivalent of 'Keep lines together'

  • Thread starter Thread starter Fred Smith
  • Start date Start date
F

Fred Smith

I've subtotaled a table, and need to print it out. I would like all rows
which form part of the subtotal to print together on one page. If there's
not enough room on the page, I'd like a page break after the previous
subtotal.

In Word, I can use 'Keep lines together'. Is there an equivalent in Excel?

If not, how would I program this? Is it possible to tell in VBA where the
page beak is? And, if I don't like where it is, can I move it to a different
row?
 

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

variable page breaks 1
Keep Text Together 1
Divide two numbers in data subtotal function 2
MS-Excel: keep lines (rows) together 3
Issue with nested data subtotals 3
percent of row in subtotal range 1
Help with Subtotal Function 3
Creating a formula in VBA with quoted strings 1

Back
Top