how to protect column headers from sorting.
 

I am trying to sort data while protecting the header labels from being
sorted. Thank you.

There is an option in the DataSort dialog to exclude headers.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"rabbit" wrote in message
...
I am trying to sort data while protecting the header labels from being
sorted. Thank you.

Don't use the sort ascending/descending buttons.

Select all cells on the sheet and then use
Data, Sort, at the bottom is a checkbox where you indicate
if you data has headers.

http://www.mvps.org/dmcritchie/excel/sorting.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"rabbit" wrote in message ...
I am trying to sort data while protecting the header labels from being
sorted. Thank you.

I believe the 'Header Row' option in the sort covers only 1 row.

To sort where there are multiple row headers (and also to protect Row
Totals if necessary) select the rows that you require to be sorted
either by click-and-drag the row numbers, or by typing the range into
the name box
(as say 6:65536 for 5 header rows,
or 6:30 for 5 header rows, 26 data rows and total rows at 31 onwards)
and then do your sort leaving the 'Heading row' unticked.
Use the 'ascending/descending' and additions sort keys as required.

Hope this helps


David McRitchie Wrote:
Don't use the sort ascending/descending buttons.

Select all cells on the sheet and then use
Data, Sort, at the bottom is a checkbox where you indicate
if you data has headers.

http://www.mvps.org/dmcritchie/excel/sorting.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"rabbit" wrote in message
...
I am trying to sort data while protecting the header labels from
being
sorted. Thank you.


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=395547