3. Look behind the dialog box. If you can see the row numbers that you want to repeat, click on the first row and drag down to the last row. Excel should fill in $1:$5 for you. Alternatively, you could type this text or use the RefEdit button at the right edge of the box.
4. There is a Print Preview button at the bottom of the dialog. Check page 2 of the Print Preview to see if the rows are appearing correctly.