Using range of cells as headers

[mikerascally]

Hi,
How do you select a range of cells to use as the header so that it will automatically appear when printing?

Thanks!

 

[xlbo]

if you mean on every page then go
File>Pagesetup>Sheet
and choose the row after clicking in the "Rows to repeat at top" box

Rgds, Geoff

Yesterday it worked. Today it is not working. Windows is like that.

Please read FAQ222-2244 before you ask a question

 

[mikerascally]

Hey Great! Thanks. Never thought of going to pagesetup!...need sleep!