In XL ... hidden rows *DON'T SORT*!

So, hide the blank rows:

Click in the datalist and hit
<F5
Click "Special"
Click "Blanks"
Click <OK

Your blank rows are all selected.
Now, from the toolbar
<Format <Row <Hide

Select your datalist and perform your normal sort.

After the sort, while the list is *still* selected, reverse the hide:
<Format <Row <UnHide

And you should be back where you started, with your data sorted and blank
rows between them.

--

HTH,

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

"Erin" wrote in message
...
We have a list from our school district that needs to have spaces inbetween
the typed in fields. When we add new people to the list and try to sort it,
we can not get it to keep the spaces inbetween the names...help!