View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
agfox35 agfox35 is offline
external usenet poster
 
Posts: 2
Default sort Excel 2007 to include empty row between data?

I have a dB of names with a blank row separating each grouping [a, b, c etc],
but every time I sort the list, the blank rows go to the top of the
spreadsheet. Is there a way to keep the empty row in place when sorting? My
interim solution is to end each group with az, bz, cz, etc. Your thoughts are
appreciated.