How do I sort multiple pages with headers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Look at Page Setup | Sheet | Rows to repeat at top

Regards

Trevor
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Excel in Formatted Output 2
Sorting day names chronologically 5
Sum from two pages 4
Multiple Column Sorting 2
Report - Sorting and Grouping 1
Worksheet 2
Drop Down Sort Button. 2
Access Page Header with merge field 0

Back
Top