| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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é |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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é |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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é |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lines Between rows | Excel Discussion (Misc queries) | |||
| how to delete rows which is blank and which has ======== ( lines) | Excel Discussion (Misc queries) | |||
| In Excel 2007 chart with multiple lines, mouse doesn't track lines | Charts and Charting in Excel | |||
| How do I put lines between rows that can be seen when printing? | Excel Discussion (Misc queries) | |||
| How do I add lines to my rows and columns? | Setting up and Configuration of Excel | |||
Linear Mode
