How to exclude header row from sort button sorts?

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?

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

On Fri, 25 Mar 2005 05:15:03 -0800, "JCabo" <[email protected]>
wrote:

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