Header for every page

[Bobby]

Good day.

How can I create a header row on my long list as such that during
printing (or print preview), a header row will appear automatically
after each page break.
(Instead of manually typing in the cells on each page end.)

Thank you.

Bobby

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software!
http://www.ozgrid.com/Services/excel-software-categories.htm **

 

[Ragdyer]

This will use designated rows of the existing WS itself to be duplicated at
the start of every page.

<File> <PageSetUp> <Sheet> tab,
Under "PrintTitles", you can enter the row(s) that you wish to have
repeated.
ie ... 1:1 or 1:2

If you wish for the header to be independent text, not associated with
existing data on the WS, you can use:

<File> <PageSetUp> <Header/Footer> tab,
Where you can choose from some existing samples, or you can create something
distinctive for your purposes.