Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Turquoise_dax
 
Posts: n/a
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.misc
Franz Verga
 
Posts: n/a
Default 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


  #3   Report Post  
Posted to microsoft.public.excel.misc
Turquoise_dax
 
Posts: n/a
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Want to print only rows that have value in certain columns- Excel pwalk Excel Discussion (Misc queries) 2 June 15th 06 07:23 PM
Removing Rows for Printing Frick Excel Worksheet Functions 20 March 10th 06 11:53 PM
How do I stop Excel print settings from transfering? Albertsons Erik Excel Discussion (Misc queries) 0 December 5th 05 10:54 PM
deleting hidden rows so i can print only the rows showing?????? jenn Excel Worksheet Functions 0 October 6th 05 05:05 PM
Repeating Rows and Columns on each page of print out BruceM Excel Discussion (Misc queries) 1 July 6th 05 01:28 PM


All times are GMT +1. The time now is 04:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"