Repeating Different Rows in Excel

Question

I am wondering if there is a way to repeat different row headers to subsequent pages. 

I have a worksheet that has multiple sections. At each section I would like to be able to have a different set of headers begin repeating on each subsequent page, until the next section comes up.  

It looks as if I can only repeat one set of headers and that's it. Is there a way to repeat different sets of headers throughout the document...or am I stuck with just the one?

Thanks,

-LT

Answer 1

Hi,

Thank you for choosing Microsoft Community.

I need more information in order to assist you further.

When you state ‘I would like to be able to have a different set of headers begin repeating on each subsequent page, until the next section comes up’, do you want this task to be automated?

What do you mean multiple sections, are you referring to range and sheets?

Do get back to us with the required details so that we may assist you better.

Thank you.