MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Print header column

Posted by Ken on July 06, 2001 7:42 AM

I have a sheet that I put column headers in row one.
Is there a way to have that column with headers print
on every page? Thank you in advance.

Posted by Ben O. on July 06, 2001 7:57 AM

In Excel 2000: Go to File > Page Setup and click on the "Sheet" tab. Under "Print Titles", click on the collapse button that says "Rows to Repeat at top" and select the appropriate rows.

-Ben O.

Posted by Ken on July 06, 2001 8:03 AM