Go to Format ▸ Print Ranges ▸ Edit. Select the Print Range (data to print) Click on the box to the right of Rows to repeat or Columns to repeat. Select the row(s)/column(s) to be repeated. Click OK.