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 !
---------------------------------------------------------------------------
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....
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!
=====================================================
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