How to exclude header row from sort button sorts?

[JCabo]

I have a large spread sheet that I like to sort alot of different ways using
the sort buttons on the tool bar. I know how to use the Data - Sort function
and selecting header row or not. I want Excel to remember I have a Header Row
when I use the toolbar buttons. It used to remember, but somehow it doesn't
anymore? How can I make this always work?

 

[Gord Dibben]

I find Excel will rcognize a header row if the cells in that row are formatted
to Bold or Underline or some other format that will distinguish it from the
cells below.


Gord Dibben Excel MVP