Rows to repeat at the top different pages

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3144156%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Bes-ES%5C%26quot%3B%22%3ERows%20to%20repeat%20at%20the%20top%20different%20pages%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3144156%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Bes-ES%5C%26quot%3B%22%3E%3CP%3EHow%20is%20it%20possible%20that%20there%20is%20no%20option%20to%20put%20more%20than%20one%20repetition%20range%20per%20sheet.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3ESorry%20for%20my%20level%20of%20English%20thanks.%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3144156%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Bes-ES%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
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