Perhaps a "low tech" solution might be appropriate....

If the blank rows are only spacers to make the data more visible
you could remove all of the blank rows and just double the row heights.
The effect would be the same.

If that's acceptable....An easy way to remove the blank rows:
Select the single-column range of names
Press [F5].......a shortcut for <edit<goto
Click: [Specal..]
Check: Blanks
Click [OK]
(now the blank cells are selected)

<edit<delete<entire row...Click [OK]

Is that something you can work with?
Post back if you have more questions.

Regards,

Ron
Microsoft MVP - Excel


"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