Print first row at top of each page EXCEL

[darinmc]

Hi
We have a rota, the page breaks have been set and I would like to have the top row which contains the Day & date, to be printed at the top of each page, preferably in the Header area...

Is this posible?
how would i go about this?

Thx
Darin

 

[SkipVought]

Hi,

File > Page Setup - Sheet Tab -- ROWS TO REPEAT AT TOP.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[darinmc]

Thx
That seems to do the trick for now...