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

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

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" <(E-Mail Removed)> wrote in message
news4E9BB49-0F85-4C7F-AA9A-(E-Mail Removed)...
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

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" <(E-Mail Removed)> wrote in message news:uihsSA%(E-Mail Removed)...
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" <(E-Mail Removed)> wrote in message
news4E9BB49-0F85-4C7F-AA9A-(E-Mail Removed)...
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

In microsoft.public.excel on Sat, 10 Nov 2007, RagDyeR
<(E-Mail Removed)> 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)

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

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" <(E-Mail Removed)> wrote in message
news:3906AE6C-8C1D-48E2-98B8-(E-Mail Removed)...
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" <(E-Mail Removed)> wrote in message
news:uihsSA%(E-Mail Removed)...
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" <(E-Mail Removed)> wrote in message
news4E9BB49-0F85-4C7F-AA9A-(E-Mail Removed)...
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

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

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
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

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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> 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