How do I make the sort default to 'No header rows'

I often sort a range of cells using the sort ascending arrows. Most of the
time the first row is not sorted due to Excel assuming that the first row is
a header.
How do I make the default "No header rows" so that the sort ascending works
without having to use Data, Sort

I don't know of any way, Ctrl+Z is your friend, so if it doesn't work
use Data Sort

You could write your own macros, and assign to your own toolbar button
http://www.mvps.org/dmcritchie/excel/toolbars.htm

Sub SortAscending_NoHeader()
Cells.Sort Key1:=ActiveCell, _
Order1:=xlAscending, Header:=xlNo, _
OrderCustom:=1, MatchCase:=False, _
Orientation:=xlTopToBottom
End Sub
Sub SortAscending_Header()
Cells.Sort Key1:=ActiveCell, _
Order1:=xlAscending, Header:=xlYes, _
OrderCustom:=1, MatchCase:=False, _
Orientation:=xlTopToBottom
End Sub


--
---
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

"DJT" <[email protected]> wrote in message news:[email protected]...
> I often sort a range of cells using the sort ascending arrows. Most of the
> time the first row is not sorted due to Excel assuming that the first row is
> a header.
> How do I make the default "No header rows" so that the sort ascending works
> without having to use Data, Sort