When I sort a list, How can I keep blank rows between the fields?
 

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!

When I sort a list, How can I keep blank rows between the fields?
 

Hi

This has not been tested, but should work. I would hightlight the
column that that I wanted to sort. Once this is done I would use the
menu Data -- Filter-- NonBlanks. Once sorted I would use the menu
Data --- sort

Let me know if this works.

Denis


--
jetted
------------------------------------------------------------------------
jetted's Profile: http://www.excelforum.com/member.php...o&userid=17532
View this thread: http://www.excelforum.com/showthread...hreadid=564984