Hi Carman,
You have to print pages 1-10 separately for page 11-20 using
the two different headers. 1-10 separately for the other sheet
and 11-20 with no headers.

You can do that within a macro.
Headings for Columns, and Page Numbering
http://www.mvps.org/dmcritchie/excel/headcols.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Carman Law" <Carman Law@discussions.microsoft.com> wrote in message news:47F761AE-29A5-4B89-B8D5-A3DC88A9C6D1@microsoft.com...
> Would like to ask
> 1. How to print a row title in say pages 1-10 and another row title in pages
> 11-20 within one sheet?
> 2. Print row titles in pages 1-10 and then no row titles in pages 11-20
> within one sheet?
>
> Thanks