ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Print settings / Can rows be constrained? (https://www.excelbanter.com/excel-discussion-misc-queries/96307-print-settings-can-rows-constrained.html)

Turquoise_dax

Print settings / Can rows be constrained?
 

Is it possible to constrain a serie of rows so that they cannot print on
different pages? If so, how?

(I simply do not want a subtitle row to print at the end of a page and
then the 3 associated rows on the next page.)

I have to say that setting manual page break or using custom views is
not practical for this case.

Thanx for pointing out any options....


--
Turquoise_dax
------------------------------------------------------------------------
Turquoise_dax's Profile: http://www.excelforum.com/member.php...o&userid=35185
View this thread: http://www.excelforum.com/showthread...hreadid=556109


Franz Verga

Print settings / Can rows be constrained?
 
Nel post news:Turquoise_dax.2a2kwz_1151426701.9189@excelfor um-nospam.com
*Turquoise_dax* ha scritto:

Is it possible to constrain a serie of rows so that they cannot print
on different pages? If so, how?

(I simply do not want a subtitle row to print at the end of a page and
then the 3 associated rows on the next page.)

I have to say that setting manual page break or using custom views is
not practical for this case.

Thanx for pointing out any options....


You can simply hide the rows you don't want to print: select the rows to
hide, menu Format, Row, Hide.


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy



Turquoise_dax

Print settings / Can rows be constrained?
 

I think you got it wrong: I do want to print the whole document, and I
need to still use automatic pagebreaks, but I would like to arrange the
document so that title rows cannot be printed alone at the end of a
page. By constraiting them to some content rows, I want to make sure
the automatic page breaks are not set right under a title row.

But maybe it cannot be done?


--
Turquoise_dax
------------------------------------------------------------------------
Turquoise_dax's Profile: http://www.excelforum.com/member.php...o&userid=35185
View this thread: http://www.excelforum.com/showthread...hreadid=556109



All times are GMT +1. The time now is 07:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com