Rows to repeat at the top different pages

New Contributor

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.

5 Replies
Can you elaborate more please

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.

@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.

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

See attached.

excel view.jpgprint view1.jpgprint view2.jpgprint view3.jpg

@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.

jitinm_1-1644491673845.pngjitinm_2-1644491680000.png