MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Keep Column heading while printing


Posted by Greg on August 16, 2001 12:30 PM

My first row tells what is in each column. This is fine for page one, but once I get to page two I cant tell what is in each column. Is there a way to get column headers to stay there for every page that is printed? Thanks a lot.
-Greg


Posted by Dax on August 16, 2001 12:32 PM

Try File, Page Setup, choose the Sheet tab and then choose the header range from the Rows to repeat at the top.

Hope it helps,
Dax.

Posted by Greg on August 16, 2001 12:40 PM

Dax,

Perfect. Thanks so much for the help. Its been bothering me for about an hour. I appreciate it.

-Greg