With the heading(titles) in row 1.

File>Page Setup>Sheet>Rows to Repeat at top.

Enter the row number 1:1 or just point to row 1.

This will print row 1 at the top of each printed page.


Gord Dibben Excel MVP

On Mon, 24 Jan 2005 15:13:03 -0800, "donnr11"
<donnr11@discussions.microsoft.com> wrote:

>I have office 2003. I have a list of names and titles that is 19 pages long.
>1000+ entries. I have headings on page one and have sorted it by the 3
>different headings with no problem. I want headings on each page so you know
>what you're looking at in each column. But if I put them in, it will not
>sort. Isn't there a way to sort all 19 pages together, with a heading on each
>page?