Repeat row(s) header on printed spreadsheet Software Effect Enterprises, Inc Posted on August 9, 2020 by SEEIAugust 9, 2020 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.