MS-Excel: keep lines (rows) together
 

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é

MS-Excel: keep lines (rows) together
 

Hi René

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

"René van Kessel" wrote:

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é

MS-Excel: keep lines (rows) together
 

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.

"Kassie" schreef in bericht
...
Hi René

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

"René van Kessel" wrote:

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é

MS-Excel: keep lines (rows) together
 

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.

"René van Kessel" wrote:

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.

"Kassie" schreef in bericht
...
Hi René

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

"René van Kessel" wrote:

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é




--

Dave Peterson