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


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s