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

[justinlind44]

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

 

[Michael Malinsky]

File>Page Setup>Sheet 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.

 

[CyberTaz]

Hi Justin-

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

Go into File>Page 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]

Thanks This was most helpful!

Hi Justin-

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

Go into File>Page 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]

Thank you This helped a lot!

File>Page Setup>Sheet 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.