Rows to include on top

Is it possible to include more than one range to be set as rows to be included on top of each page?

For ex, I need to include rows 1 to 27 and also row 56 on top of each page.

pageSetup.setPrintTitleRows("$1:$27") lets me include only rows 1-27 , will also need to include row 56.

Thanks.

Hi,


Well, I don’t think if it is possible to include non - contiguous rows, the rows/columns should be contiguous and complete rows/columns while printing tile rows/cols. For confirmation, you may check it in MS Excel manually. If you have different opinion, kindly create a template file in MS Excel to set your desired print title rows/cols and post there file here, we will check it soon.

Thank you.