Thanks in advance.
File>Page Setup>Sheet>"Rows to repeat at top". Enter $1:$1 or use collapsingbox to point to row 1.
Gord Dibben Excel MVP - XL97 SR2 on Win98SE - XLXP SP2 on WinXP