How to have header of each column print at the top of each page

[abohlig]

I am sure this is really simple, but how do I get the column header of each column to print as the 1st row on each new page that is printed. I am not talking about a header that you set up in page setup, I am talking about in excel in each column I have a header in A1, B1, C1 etc that identifies what is in that column and there are several pages worth of rows. When it prints on page 2 it is not easy to identify what is in each column as there is no header at the top of that page.

Thanks

 

[c_m_s_jr]

Under page set up select "Sheet" and then highlight the row(s) with the columns you want repeated.

 

[VoG]

Try File > Page Setup, Sheet tab, In Rows to Repeat at Top enter 1:1 then click OK.

 

[abohlig]

Under page set up select "Sheet" and then highlight the row(s) with the columns you want repeated.

Thanks,
problem solved