R
rabbit
I am trying to sort data while protecting the header labels from being
sorted. Thank you.
sorted. Thank you.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob Phillips
There is an option in the Data>Sort dialog to exclude headers.
--
HTH
RP
(remove nothere from the email address if mailing direct)
--
HTH
RP
(remove nothere from the email address if mailing direct)
D
David McRitchie
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
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
B
Bryan Hessey
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 Ro
Totals if necessary) select the rows that you require to be sorte
either by click-and-drag the row numbers, or by typing the range int
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
To sort where there are multiple row headers (and also to protect Ro
Totals if necessary) select the rows that you require to be sorte
either by click-and-drag the row numbers, or by typing the range int
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 said: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 said:I am trying to sort data while protecting the header labels fro being
sorted. Thank you