While printing any Excel sheet which run into multiple pages’ prints, you may want to have the 1st row of your data to be repeated on each of the printed pages.

Let’s say your data consists of the following fields:

  • Product Number
  • Product Name
  • Quantity
You want these column headings (1st row) to be printed on all the sheets.
 
Steps:
  1. Go to Page Layout Tab.
  2. Select Print Titles.
  3. Keep your cursor in Rows to repeat at top: , and then click on A1 (the row that you want to repeat in every print.
    • You can even select more than 1 row if needed to be printed on each page.
  4. Click OK.
 
It’s done!
Similarly, you can choose Columns to repeat at left: option too.