Designating a specific header row for sorting

[SteveTalley]

Using Excel 2000, I would like to designate a specific row as the header row when I sort. Reason: I have two rows as the header, with different information in each. I would like to designate that Row 2 is the header and sort based on that. Otherwise, I have to sort on Column B, then Column E, which is not intuitive. Any way to do this?

 

[Juan Pablo González]

Select your range starting in A2 if you want to use row 2 as header, or in A1 if you want to use row 1 as header. BTW, having two header rows doesn't seem very intuitive to me either !