You can select any number of rows to be header rows. Just highlight them before you click on Repeat Header Rows. In the following example I’ve selected three rows to repeat.
When the next page is reached, you can see that the heading comprises the three rows.