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

 

[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