How do I sort multiple pages with headers

[donnr11]

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?

[Trevor Shuttleworth]

Look at Page Setup | Sheet | Rows to repeat at top

Regards

Trevor


"donnr11" <donnr11@discussions.microsoft.com> wrote in message
news:221B3B8D-1F25-4D2A-97D7-0C32E0B9A541@microsoft.com...
>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?

[Gord Dibben]

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?