Friday, August 26, 2011

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

Go to this site for know the steps in Excel 2007/2010:  http://www.lytebyte.com/2009/08/18/how-to-print-first-row-or-header-row-on-every-page-in-excel/

In Excel 2003:

1) Go to View Menu bar
2) Click Header and Footer
3) Go to Sheet Tab
4) Click Rows to repeat at top option in Print titles
5) Select First row by clicking at position Row1 and Press enter
6) Now prints the page. You will get desire output.


No comments:

Post a Comment