In addition to Headers do you use the "rows to repeat at top" on the
page set-up...sheet options? If you leave a blank row between your
header and the data section (even if the row is hidden) then the header
will not get included in the data section.

Rather fewer option for footers : only the normal Excel Footer

regards


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=564203