Rows to repeat at the top different pages

[vnavarroma]

How is it possible that there is no option to put more than one repetition range per sheet.

I want to display in the print view pages 1 and 2 the cells 1:2 as page header and on the rest pages the cells 20:23 and don't use macros.

Sorry for my level of English thanks.

[#2]

Can you elaborate more please

[#3]

I want to display in the print view pages 1 and 2 the cells 1:2 as page header and on the rest pages the cells 20:23 and don't use macros.
Thank you.

[#4]

@vnavarromaYou can make a gap in sheet2 on top with your respective headers(2 rows) by opening Page Break Preview and later change to Normal view. See attached.

[#5]

Hi @jitinm, the user does not want to add the headers in the normal view and that they appear in the printout.

See attached.

[#6]

@vnavarroma

I hope this is what you want. In sheet you won't find Title and Subtitle however it is reflecting in the print layout. See excel attachment.