LyteByte

While using Excel, most often the contents overflow to multiple pages and you may have the header row on top on the first page and you would have frozen it on top so that when you scroll down the header is still visible. But when you print any Excel sheet, it would be great to have the header row or the first row printed on top of each and every page for better readability. Also see how to print first column or header column on every page in Excel.

So how to print header row or first row on each and every page in Excel?

This tip applies to Office 2010 and Office 2007.

Go to Page Layout and click on the Print Titles under Page Setup.

In the Page Setup, Under Print titles, click the red arrow icon next to Rows to repeat at top.

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

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

Enable Row and Column Headings

Also if you want to row headings which says column A, B, C etc or Row headings or number 1,2,3 then you can enable them under Page Layout –> Sheet Options –> Check Print under Headings.

Here in the Print Preview (Use Keyboard shortcut Ctrl +F2) you can see that the first row and the row and column header is being printed on all pages.

Also see how to print first column or header column on every page in Excel.