Sort data with blank rows dividing data

[Sheila]

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?

 

[Sanjay]

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]

Sanjay:

I don't understand what you're saying. How do I use the filter to select
all blank rows?

 

[phildy]

Select the first row (click on 1 at left hand side).

From the tool bar select Data|Filter|Auto Filter

A drop down arrow should apear on the first cell in each column.

Use one of these drop down arrows and select 'non blank' cells.

Sort the cells as required.

Use the drop down arrow again and filter to 'all'.

Job done.

 

[Sheila]

When I click on the drop down arrows, the only choices I have are Sort
Ascending, Sort Decending, (All), (Top 10), and (Custom). Am I missing
something?

 

[phildy]

Sorry - my error.

Instead of selecting the first row as suggested select all cells by clicking
on the grey box above 1.

The rest is as before