Sort/Header

TheMSsForum.com: The Microsoft Software Forum

This is a multi-part message in MIME format.

------=_NextPart_000_000A_01C823A2.BBAB50E0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Many times I will sort data and the sort command automatically =
recognizes the header.
I have a new sheet that Sort does not recognize the header so it mixes =
the header in with the dataset.
How do I identify or mark row 1 as my header for a data table?
Thanks,
Minkx
------=_NextPart_000_000A_01C823A2.BBAB50E0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.6000.16546" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Many times I will sort data and the =
sort command=20
automatically recognizes the header.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I have a new sheet that Sort does not =
recognize the=20
header so it mixes the header in with the dataset.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>How do I identify or mark row 1 as my =
header for a=20
data table?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Thanks,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Minkx</FONT></DIV></BODY></HTML>

------=_NextPart_000_000A_01C823A2.BBAB50E0--
Top

Re: Sort/Header by Pete_UK

Pete_UK
Sat Nov 10 13:14:46 PST 2007

You need to make it distinguishable from the data to help Excel guess
that you have a header, so format it with Bold, or a different
background colour, or a larger font size.

Hope this helps.

Pete

On Nov 10, 9:05 pm, "Minkx" <mi...@comcast.net> wrote:
> Many times I will sort data and the sort command automatically recognizes the header.
> I have a new sheet that Sort does not recognize the header so it mixes the header in with the dataset.
> How do I identify or mark row 1 as my header for a data table?
> Thanks,
> Minkx


Top

Re: Sort/Header by RagDyeR

RagDyeR
Sat Nov 10 13:22:24 PST 2007

You can help XL automatically recognize a header row by doing anything that
changes that row from the rest of the datalist - bold, larger font size,
different color.

Primarily, just check the box at the bottom of the initial sort window which
stipulates that you *do* have a header row.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

"Minkx" <minkx@comcast.net> wrote in message
news:D4E9BB49-0F85-4C7F-AA9A-24C4366CCE1C@microsoft.com...
Many times I will sort data and the sort command automatically recognizes
the header.
I have a new sheet that Sort does not recognize the header so it mixes the
header in with the dataset.
How do I identify or mark row 1 as my header for a data table?
Thanks,
Minkx


Top

Re: Sort/Header by Minkx

Minkx
Sat Nov 10 18:35:02 PST 2007

This is a multi-part message in MIME format.

------=_NextPart_000_0020_01C823D0.C990D120
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Does this work in compatibility mode? 'Cuz it ain't working for me at =
all. I changed the font & made it bold with a blue backgound. But it =
still jumps into the sort with the rest of the data. I know about the =
check box, but a simple sport A->Z shouldn't require I open the dialog =
box and click, click, click, click, click....
"RagDyeR" <ragdyer@cutoutmsn.com> wrote in message =
news:uihsSA%23IIHA.4476@TK2MSFTNGP06.phx.gbl...
You can help XL automatically recognize a header row by doing anything =
that=20
changes that row from the rest of the datalist - bold, larger font =
size,=20
different color.

Primarily, just check the box at the bottom of the initial sort window =
which=20
stipulates that you *do* have a header row.
--=20

HTH,

RD
=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D
Please keep all correspondence within the Group, so all may benefit!
=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

"Minkx" <minkx@comcast.net> wrote in message=20
news:D4E9BB49-0F85-4C7F-AA9A-24C4366CCE1C@microsoft.com...
Many times I will sort data and the sort command automatically =
recognizes=20
the header.
I have a new sheet that Sort does not recognize the header so it mixes =
the=20
header in with the dataset.
How do I identify or mark row 1 as my header for a data table?
Thanks,
Minkx=20



------=_NextPart_000_0020_01C823D0.C990D120
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.6000.16546" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Does this work in compatibility mode? =
'Cuz it ain't=20
working for me at all. I changed the font &amp; made it bold with a blue =

backgound. But it still jumps into the sort with the rest of the data. I =
know=20
about the check box, but a simple sport A-&gt;Z shouldn't require I open =
the=20
dialog box and click, click, click, click, click....</FONT></DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"RagDyeR" &lt;<A=20
href=3D"mailto:ragdyer@cutoutmsn.com">ragdyer@cutoutmsn.com</A>&gt; =
wrote in=20
message <A=20
=
href=3D"news:uihsSA%23IIHA.4476@TK2MSFTNGP06.phx.gbl">news:uihsSA%23IIHA.=
4476@TK2MSFTNGP06.phx.gbl</A>...</DIV>You=20
can help XL automatically recognize a header row by doing anything =
that=20
<BR>changes that row from the rest of the datalist - bold, larger font =
size,=20
<BR>different color.<BR><BR>Primarily, just check the box at the =
bottom of the=20
initial sort window which <BR>stipulates that you *do* have a header=20
row.<BR>--=20
=
<BR><BR>HTH,<BR><BR>RD<BR>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D<BR>Please=20
keep all correspondence within the Group, so all may=20
=
benefit!<BR>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D<BR><BR>"Minkx"=20
&lt;<A href=3D"mailto:minkx@comcast.net">minkx@comcast.net</A>&gt; =
wrote in=20
message <BR><A=20
=
href=3D"news:D4E9BB49-0F85-4C7F-AA9A-24C4366CCE1C@microsoft.com">news:D4E=
9BB49-0F85-4C7F-AA9A-24C4366CCE1C@microsoft.com</A>...<BR>Many=20
times I will sort data and the sort command automatically recognizes =
<BR>the=20
header.<BR>I have a new sheet that Sort does not recognize the header =
so it=20
mixes the <BR>header in with the dataset.<BR>How do I identify or mark =
row 1=20
as my header for a data table?<BR>Thanks,<BR>Minkx=20
<BR><BR><BR></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_0020_01C823D0.C990D120--

Top

Re: Sort/Header by Paul

Paul
Sun Nov 11 00:27:12 PST 2007

In microsoft.public.excel on Sat, 10 Nov 2007, RagDyeR
<ragdyer@cutoutmsn.com> wrote :

>You can help XL automatically recognize a header row by doing anything that
>changes that row from the rest of the datalist - bold, larger font size,
>different color.

I always wondered why excel sometimes seems to recognise header rows,
and not at other times!
--
Paul Hyett, Cheltenham (change 'invalid83261' to 'blueyonder' to email me)
Top

Re: Sort/Header by Dave

Dave
Sun Nov 11 05:44:45 PST 2007

You may want to try feezing the panes so that row 1 (or where ever the headers
stop) is always visible.

ps. You may have noticed that this is a plain text newsgroup. HTML posts and
attachments aren't appreciated by most people.


--

Dave Peterson
Top

Re: Sort/Header by JP

JP
Sun Nov 11 10:27:42 PST 2007

If you highlight the entire data range (incl headers) you should be
able to tell XL that the first row is a header, even if it isn't
bolded or colored in some way. When you choose Data|Sort there should
be an option "My list has" -- you should choose "Header Row"


HTH,
JP

On Nov 10, 4:05 pm, "Minkx" <mi...@comcast.net> wrote:
> Many times I will sort data and the sort command automatically recognizes the header.
> I have a new sheet that Sort does not recognize the header so it mixes the header in with the dataset.
> How do I identify or mark row 1 as my header for a data table?
> Thanks,
> Minkx


Top

Re: Sort/Header by Ragdyer

Ragdyer
Sun Nov 11 10:23:54 PST 2007

Do I read into your post that you use the sort icons on the toolbar?

I strongly suggest that you *never, never, never* use those icons.

XL may be right most of the time, but as you may be experiencing, *not all*
of the time.

In fact, I have removed those icons from the toolbars of all the machines in
all of my plants.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Minkx" <minkx@comcast.net> wrote in message
news:3906AE6C-8C1D-48E2-98B8-B86033131725@microsoft.com...
Does this work in compatibility mode? 'Cuz it ain't working for me at all. I
changed the font & made it bold with a blue backgound. But it still jumps
into the sort with the rest of the data. I know about the check box, but a
simple sport A->Z shouldn't require I open the dialog box and click, click,
click, click, click....
"RagDyeR" <ragdyer@cutoutmsn.com> wrote in message
news:uihsSA%23IIHA.4476@TK2MSFTNGP06.phx.gbl...
You can help XL automatically recognize a header row by doing anything
that
changes that row from the rest of the datalist - bold, larger font size,
different color.

Primarily, just check the box at the bottom of the initial sort window
which
stipulates that you *do* have a header row.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

"Minkx" <minkx@comcast.net> wrote in message
news:D4E9BB49-0F85-4C7F-AA9A-24C4366CCE1C@microsoft.com...
Many times I will sort data and the sort command automatically recognizes
the header.
I have a new sheet that Sort does not recognize the header so it mixes the
header in with the dataset.
How do I identify or mark row 1 as my header for a data table?
Thanks,
Minkx



Top

Re: Sort/Header by Minkx

Minkx
Sun Nov 11 10:36:09 PST 2007

Thanks for the notice of this being a plain text NG. I was not aware of
that. I will adjust my settings accordingly.
Freezing the panes does not stop the sort from including that row in the
sort.The resulting sort places data in that row.
Any other ideas?

"Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
news:4737074D.86BFF14C@verizonXSPAM.net...
You may want to try feezing the panes so that row 1 (or where ever the
headers
stop) is always visible.

ps. You may have noticed that this is a plain text newsgroup. HTML posts
and
attachments aren't appreciated by most people.


--

Dave Peterson

Top

Re: Sort/Header by Dave

Dave
Sun Nov 11 12:15:03 PST 2007

If you can't get excel to guess correctly that you have header rows, maybe you
can use a macro to sort your data--if you always sort by a certain sequence of
fields, it may even work.

I don't recall you posting the version of excel you're using, but in xl2003
(maybe xl2007, too), you can apply data|filter|autofilter and use the dropdown
arrow to choose to sort that table by that field/column.

Or you may like a macro that uses invisible rectangles over the headers that
allows you to sort your data based on the column of the rectangle that you
clicked.

If you want to try that, check out Debra Dalgleish's site:
http://contextures.com/xlSort02.html

ps. I never trust excel to guess what I want sorted. I always select my
complete range and use data|sort and specify if I have a header row.

Minkx wrote:
>
> Thanks for the notice of this being a plain text NG. I was not aware of
> that. I will adjust my settings accordingly.
> Freezing the panes does not stop the sort from including that row in the
> sort.The resulting sort places data in that row.
> Any other ideas?
>
> "Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
> news:4737074D.86BFF14C@verizonXSPAM.net...
> You may want to try feezing the panes so that row 1 (or where ever the
> headers
> stop) is always visible.
>
> ps. You may have noticed that this is a plain text newsgroup. HTML posts
> and
> attachments aren't appreciated by most people.
>
> --
>
> Dave Peterson

--

Dave Peterson
Top

Re: Sort/Header by Ragdyer

Ragdyer
Sun Nov 11 12:15:13 PST 2007

Have you actually:
Selected your *entire* datalist, *including* the header row,
Clicked on <Data> <Sort>,
And under "My List Has"
Checked the <Header Row> option,
And notice that XL *de-selects* the header row,
And then complete the sort?

Have you done this?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Minkx" <minkx@comcast.net> wrote in message
news:0980DD97-DBF6-46F5-91A0-4267ED9CBBCD@microsoft.com...
> Thanks for the notice of this being a plain text NG. I was not aware of
> that. I will adjust my settings accordingly.
> Freezing the panes does not stop the sort from including that row in the
> sort.The resulting sort places data in that row.
> Any other ideas?
>
> "Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
> news:4737074D.86BFF14C@verizonXSPAM.net...
> You may want to try feezing the panes so that row 1 (or where ever the
> headers
> stop) is always visible.
>
> ps. You may have noticed that this is a plain text newsgroup. HTML posts
> and
> attachments aren't appreciated by most people.
>
>
> --
>
> Dave Peterson
>

Top

Re: Sort/Header by Minkx

Minkx
Mon Nov 12 06:50:37 PST 2007

I have and this works find. But I have several different fields that I am
sorting between. I have a number of other files that work just fine. i.e.:
select any cell in a column | click the Sort A->Z and XL knows there is a
header row. This one file does not play well with Sort and includes the
header as part of the dataset. Very frustrating. There must be a way to set
a header in XL without going through the Custom Sort dialog box and checking
My data has headers.
Thanks,
Minkx

"Ragdyer" <RagDyer@cutoutmsn.com> wrote in message
news:O9Mug$JJIHA.5684@TK2MSFTNGP06.phx.gbl...
> Have you actually:
> Selected your *entire* datalist, *including* the header row,
> Clicked on <Data> <Sort>,
> And under "My List Has"
> Checked the <Header Row> option,
> And notice that XL *de-selects* the header row,
> And then complete the sort?
>
> Have you done this?
> --
> Regards,
>
> RD
>
> ---------------------------------------------------------------------------
> Please keep all correspondence within the NewsGroup, so all may benefit !
> ---------------------------------------------------------------------------
> "Minkx" <minkx@comcast.net> wrote in message
> news:0980DD97-DBF6-46F5-91A0-4267ED9CBBCD@microsoft.com...
>> Thanks for the notice of this being a plain text NG. I was not aware of
>> that. I will adjust my settings accordingly.
>> Freezing the panes does not stop the sort from including that row in the
>> sort.The resulting sort places data in that row.
>> Any other ideas?
>>
>> "Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
>> news:4737074D.86BFF14C@verizonXSPAM.net...
>> You may want to try feezing the panes so that row 1 (or where ever the
>> headers
>> stop) is always visible.
>>
>> ps. You may have noticed that this is a plain text newsgroup. HTML
>> posts
>> and
>> attachments aren't appreciated by most people.
>>
>>
>> --
>>
>> Dave Peterson
>>
>

Top

Re: Sort/Header by Minkx

Minkx
Mon Nov 12 06:58:08 PST 2007

I have and this works find. But I have several different fields that I am
sorting between. I have a number of other files that work just fine. i.e.:
select any cell in a column | click the Sort A->Z and XL knows there is a
header row. This one file does not play well with Sort and includes the
header as part of the dataset. Very frustrating. There must be a way to set
a header in XL without going through the Custom Sort dialog box and checking
My data has headers.
I use the sort function ALOT. I want this to work properly and as expected
or to know what I have to do to make the header row a header row.
I can also highlight the whole worksheet except the header and go through
the sort dialog without the My data has a header. BUT that does not make
sense! If I select nearly any other function, once I indicate the header it
should always be my header. It's not "sticking".

"JP" <jpena@sterlingtesting.com> wrote in message
news:1194805662.018699.112470@50g2000hsm.googlegroups.com...
> If you highlight the entire data range (incl headers) you should be
> able to tell XL that the first row is a header, even if it isn't
> bolded or colored in some way. When you choose Data|Sort there should
> be an option "My list has" -- you should choose "Header Row"
>
>
> HTH,
> JP
>
> On Nov 10, 4:05 pm, "Minkx" <mi...@comcast.net> wrote:
>> Many times I will sort data and the sort command automatically recognizes
>> the header.
>> I have a new sheet that Sort does not recognize the header so it mixes
>> the header in with the dataset.
>> How do I identify or mark row 1 as my header for a data table?
>> Thanks,
>> Minkx
>
>
>

Top

Re: Sort/Header by Minkx

Minkx
Mon Nov 12 06:52:25 PST 2007

What's the difference between the Toolbar and the Ribbon? I'm using the
ribbon - I presume we are talking about the same button.
Minkx
"Ragdyer" <RagDyer@cutoutmsn.com> wrote in message
news:OdZeTBJJIHA.5400@TK2MSFTNGP04.phx.gbl...
> Do I read into your post that you use the sort icons on the toolbar?
>
> I strongly suggest that you *never, never, never* use those icons.
>
> XL may be right most of the time, but as you may be experiencing, *not
> all*
> of the time.
>
> In fact, I have removed those icons from the toolbars of all the machines
> in
> all of my plants.
> --
> Regards,
>
> RD
>
> ---------------------------------------------------------------------------
> Please keep all correspondence within the NewsGroup, so all may benefit !
> ---------------------------------------------------------------------------
> "Minkx" <minkx@comcast.net> wrote in message
> news:3906AE6C-8C1D-48E2-98B8-B86033131725@microsoft.com...
> Does this work in compatibility mode? 'Cuz it ain't working for me at all.
> I
> changed the font & made it bold with a blue backgound. But it still jumps
> into the sort with the rest of the data. I know about the check box, but a
> simple sport A->Z shouldn't require I open the dialog box and click,
> click,
> click, click, click....
> "RagDyeR" <ragdyer@cutoutmsn.com> wrote in message
> news:uihsSA%23IIHA.4476@TK2MSFTNGP06.phx.gbl...
> You can help XL automatically recognize a header row by doing anything
> that
> changes that row from the rest of the datalist - bold, larger font size,
> different color.
>
> Primarily, just check the box at the bottom of the initial sort window
> which
> stipulates that you *do* have a header row.
> --
>
> HTH,
>
> RD
> =====================================================
> Please keep all correspondence within the Group, so all may benefit!
> =====================================================
>
> "Minkx" <minkx@comcast.net> wrote in message
> news:D4E9BB49-0F85-4C7F-AA9A-24C4366CCE1C@microsoft.com...
> Many times I will sort data and the sort command automatically recognizes
> the header.
> I have a new sheet that Sort does not recognize the header so it mixes
> the
> header in with the dataset.
> How do I identify or mark row 1 as my header for a data table?
> Thanks,
> Minkx
>
>
>
>

Top

Re: Sort/Header by RagDyeR

RagDyeR
Mon Nov 12 07:45:11 PST 2007

So, it sounds like you're using XL07.

I would say it seems that this is *another* one of the items that MS
*hasn't* fixed in this newest version.

SO ... apparently, I can still stick to what I said about *never* allowing
XL to choose the sort range ... no matter which version you're using!
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Minkx" <minkx@comcast.net> wrote in message
news:FB427191-545B-4481-9AF3-82B509B8492C@microsoft.com...
What's the difference between the Toolbar and the Ribbon? I'm using the
ribbon - I presume we are talking about the same button.
Minkx
"Ragdyer" <RagDyer@cutoutmsn.com> wrote in message
news:OdZeTBJJIHA.5400@TK2MSFTNGP04.phx.gbl...
> Do I read into your post that you use the sort icons on the toolbar?
>
> I strongly suggest that you *never, never, never* use those icons.
>
> XL may be right most of the time, but as you may be experiencing, *not
> all*
> of the time.
>
> In fact, I have removed those icons from the toolbars of all the machines
> in
> all of my plants.
> --
> Regards,
>
> RD
>
> ---------------------------------------------------------------------------
> Please keep all correspondence within the NewsGroup, so all may benefit !
> ---------------------------------------------------------------------------
> "Minkx" <minkx@comcast.net> wrote in message
> news:3906AE6C-8C1D-48E2-98B8-B86033131725@microsoft.com...
> Does this work in compatibility mode? 'Cuz it ain't working for me at all.
> I
> changed the font & made it bold with a blue backgound. But it still jumps
> into the sort with the rest of the data. I know about the check box, but a
> simple sport A->Z shouldn't require I open the dialog box and click,
> click,
> click, click, click....
> "RagDyeR" <ragdyer@cutoutmsn.com> wrote in message
> news:uihsSA%23IIHA.4476@TK2MSFTNGP06.phx.gbl...
> You can help XL automatically recognize a header row by doing anything
> that
> changes that row from the rest of the datalist - bold, larger font size,
> different color.
>
> Primarily, just check the box at the bottom of the initial sort window
> which
> stipulates that you *do* have a header row.
> --
>
> HTH,
>
> RD
> =====================================================
> Please keep all correspondence within the Group, so all may benefit!
> =====================================================
>
> "Minkx" <minkx@comcast.net> wrote in message
> news:D4E9BB49-0F85-4C7F-AA9A-24C4366CCE1C@microsoft.com...
> Many times I will sort data and the sort command automatically recognizes
> the header.
> I have a new sheet that Sort does not recognize the header so it mixes
> the
> header in with the dataset.
> How do I identify or mark row 1 as my header for a data table?
> Thanks,
> Minkx
>
>
>
>


Top

Re: Sort/Header by JP

JP
Tue Nov 13 04:18:04 PST 2007

I understand that the sort button usually works, but the results are
unpredictable because you are asking Excel to make guesses about your
data. Unless you are ruthless about keeping everything in a tabular
format, no blank rows/cells, bolding the first row, etc, eventually
the sort button will fail you. You can guarantee success by always
selecting your entire data range first.

If you are good with the keyboard you can try Alt-D,S to quickly get
to the Sort menu, or record some macros with your favorite sorting
routines. For example you could assign the macro below to a toolbar
button.

Sub SortAscending_Header()
Cells.Sort Key1:=ActiveCell, _
Order1:=xlAscending, Header:=xlYes, _
OrderCustom:=1, MatchCase:=False, _
Orientation:=xlTopToBottom
End Sub
(taken from http://www.mvps.org/dmcritchie/excel/sorting.htm)

Just select the header cell in the column that you want to use for the
sort before running.


HTH,
JP



On Nov 12, 9:58 am, "Minkx" <mi...@comcast.net> wrote:
> I have and this works find. But I have several different fields that I am
> sorting between. I have a number of other files that work just fine. i.e.:
> select any cell in a column | click the Sort A->Z and XL knows there is a
> header row. This one file does not play well with Sort and includes the
> header as part of the dataset. Very frustrating. There must be a way to set
> a header in XL without going through the Custom Sort dialog box and checking
> My data has headers.
> I use the sort function ALOT. I want this to work properly and as expected
> or to know what I have to do to make the header row a header row.
> I can also highlight the whole worksheet except the header and go through
> the sort dialog without the My data has a header. BUT that does not make
> sense! If I select nearly any other function, once I indicate the header it
> should always be my header. It's not "sticking".
>
> "JP" <jp...@sterlingtesting.com> wrote in message
>
> news:1194805662.018699.112470@50g2000hsm.googlegroups.com...
>
>
>
> > If you highlight the entire data range (incl headers) you should be
> > able to tell XL that the first row is a header, even if it isn't
> > bolded or colored in some way. When you choose Data|Sort there should
> > be an option "My list has" -- you should choose "Header Row"
>
> > HTH,
> > JP
>

Top