Excel | Print First Row on every page

To be able to print the first row on every page, you need to do the following steps:

  • Go to the Page Layout Tab
  • Click on the Print Titles under Page Setup.

Excel Print Titles

  • Go to the Page Setup, Under Print titles
  • Click the red arrow icon next to Rows to repeat at top.

Excel 2010 Page Setup

  • Use the arrow to select the first row or the row that you want to repeat in each and every page that is printed.

Repeat Header Row or First Row in Excel

  • Use the red arrow icon again and you will be taken to Page Setup screen.
  • Click OK.

Excel Page Setup

  • Check to enable “Row and Column Headings”

Happy Printing 🙂

References: from here

Categories

One Response

Leave a Reply

Your email address will not be published. Required fields are marked *