I am trying to sort data while protecting the header labels from being
sorted. Thank you.
I am trying to sort data while protecting the header labels from being
sorted. Thank you.
There is an option in the Data>Sort dialog to exclude headers.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"rabbit" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message news:[email protected]...
> 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
Originally Posted by David McRitchie
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks