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

[Guest]

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

 

[David McRitchie]

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


--