I don't think you can set the default for an alternative see the
macros at http://www.mvps.org/dmcritchie/excel/sorting.htm#icons
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
"D T" <firstname.lastname@example.org> wrote in message news:email@example.com...
> I opften sort a range of cells using the Sort Ascending arrow. The
> majority of the time the first row dose not sort, and when I got to
> Data, sort The "Hesre Row" is ticked.
> How do I make the default 'No Header Row' and avoid using Data, Sort