Sort with header rows

Giganews Newsgroups
Subject: Sort with header rows
Posted by:  Bonnie Keithley (keithl…@midamerica.net)
Date: Fri, 10 Oct 2003

Using Excel 2000

I have a table to sort, but the top three rows are all header rows.  This
prevents me from using the Data | Sort option because the "header row"
option only eliminates the first row from the sort.

All I know to do is select all the rows in the table that need to be sorted
and then use the Data | Sort option and check the "no header row" box.  This
gets cumbersome when there are hundreds of rows in the table to include in
the sort and only three rows in the table to exclude from the sort.

Any ideas?

Replies