Thread: When I sort a list, How can I keep blank rows between the fields?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
jetted jetted is offline
external usenet poster
  
Posts: 1
Default 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

Reply With QuoteReply With Quote