How to Print Header Row or First Row on Each and Every Page in Excel?

10:15 AM Technology Enthusiast 0 Comments

 excel2007 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.
Excel Print Titles
In 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
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.
Print Headings In Excel
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.
Excel 2010 Preview
Excel 2010 Preview

0 comments: