Hi Sheila,

use filter to select all blank cell and then put any value in corresponding
cell then sort both the row( ALT+d+s)

Sanjay

"Sheila" wrote:

I need to sort data in a Excel 2003 table while retaining the blank rows in
between the data. Every time I perform a regular sort, the blank rows are
returned at the end of the table. I need them to remain between each data
row. Is there a way to do this?