Rows to repeat at the top different pages

Question

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.

jitinm · Answer

Can you elaborate more please

vnavarroma · Answer

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.

jitinm · Answer

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.

vnavarroma · Answer

Hi&nbsp;jitinm,&nbsp;the user does not want to add the headers in the normal view and that they appear in the printout.See attached.

jitinm · Answer

vnavarroma&nbsp;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.&nbsp;

Forum Discussion

Rows to repeat at the top different pages

5 Replies

Resources