*Hidden* rows don't sort.

Select your datalist and hit <F5,
Click on "Special", and click on "Blanks", then <OK.

From the "Menu Bar",
<Format <Row <Hide

Select the visible cells of the datalist, and sort as desired.

Then, again from the "Menu Bar",
<Format <Row <UNHide

And you're done!
--
HTH,

RD

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

"Sandy" wrote in message
...
I am constantly adding names & phones #'s, etc. to a data sheet I have so
I
need to re-alphabetize each time I add one. I had a space between each
row,
but when I hit the Sort button, it lumps all the spaces together! Help,
please!
Sandy