Want labels of columns to display on each page when printing work.
 

I am tring to print a work book with many pages and would like to have the
titles of my columns display on each page. I have tried the header function
and it does not line up correctly with the correct columns. Any advice?
Thank you in advance.

Allen

FilePage SetupSheet tab. Go to the "Rows to repeat at top" box and either
type in the rows you want to repeat at the top of each page or use the mouse
to highlight the rows.

"justinlind44" wrote in message
...
I am tring to print a work book with many pages and would like to have the
titles of my columns display on each page. I have tried the header
function
and it does not line up correctly with the correct columns. Any advice?
Thank you in advance.

Allen

Hi Justin-

What you need is a feature called Rows to repeat at top -

Go into FilePage Setup and on the page labeled Sheet you will find what you
are looking for. Specify what row to be repeated (you can specify more than
one as long as they are consecutive).

BTW- if you go to Page Setup from Print Preview this feature not be available.

HTH |:)

"justinlind44" wrote:

I am tring to print a work book with many pages and would like to have the
titles of my columns display on each page. I have tried the header function
and it does not line up correctly with the correct columns. Any advice?
Thank you in advance.

Allen

Thanks This was most helpful!

"CyberTaz" wrote:

Hi Justin-

What you need is a feature called Rows to repeat at top -

Go into FilePage Setup and on the page labeled Sheet you will find what you
are looking for. Specify what row to be repeated (you can specify more than
one as long as they are consecutive).

BTW- if you go to Page Setup from Print Preview this feature not be available.

HTH |:)

"justinlind44" wrote:

I am tring to print a work book with many pages and would like to have the
titles of my columns display on each page. I have tried the header function
and it does not line up correctly with the correct columns. Any advice?
Thank you in advance.

Allen

Thank you This helped a lot!

"Michael Malinsky" wrote:

FilePage SetupSheet tab. Go to the "Rows to repeat at top" box and either
type in the rows you want to repeat at the top of each page or use the mouse
to highlight the rows.

"justinlind44" wrote in message
...
I am tring to print a work book with many pages and would like to have the
titles of my columns display on each page. I have tried the header
function
and it does not line up correctly with the correct columns. Any advice?
Thank you in advance.

Allen