Where it asks for rows to repeat, point at the rows you want. It will enter, for rows 1-5, $1:$5, which you could enter instead of pointing
I simply wish to show column headers on each page of my document. When I go to file, page setup and the sheet tab and chose print row or column headings, it requests information on the number of rows. So I put in 1-5 and I keep getting a message that it's an invalid reference or define name for rows. Does anyone know how I should communicate the number of rows to show over the columns?