MS-Excel: keep lines (rows) together

[René van Kessel]

Hello,

In MS-Word you can use the function "Keep lines together", so that MS-Word
decides where to set a page break without splitting up texts.

Can you do this in MS-Excel?

I want to export X-number of lines from Delphi and these lines must be kept
together, without line breaks. It would be nice if this is possible without
having to count rows manually.

Thank you.
René

 

[Guest]

Hi René

You can set page breaks in the View|Page Break Preview view

 

[René van Kessel]

Yes, but that is not what I mean.

I will export a block of X rows to MS-Excel (automated from Delphi) and I
want to say to Excel that this complete block of rows should be printed on
the next page if it does not fit on the current page.

In Word you can use "Keep lines together" for this.

 

[Dave Peterson]

There's nothing builtin to excel that does this. You could do it manually
(Kassie's recommendation), but if you change printers, you may have to do it
again.