Sorting with blank lines

S

Snip

How can I sort my data in Excel without losing the blank
line I have inserted between each item. Everytime I sort
the blank line is deleted and the items are smacked up
against each other. I inserted the blank line so there
would be a recognizable space between each entry.

Thanks for any help
 
D

Don

Hi Snip,

Don't think you can do this without VBA help but you might
try increasing the row height....this will put the data
further apart assuming you leave the font size the way it
is and all cells are formatted vertically the same.

If you're using Borders, that probably won't help you, but
it's a thought.

HTH,

Don
 
R

Ragdyer

In XL, hidden rows (columns) *don't* sort.

So ... hide the blank rows!

Select all your data, then:
<Data> <Filter> <AutoFilter>.
Click the small down arrow in any column, and choose "Non-Blanks".

You now have *all* your data selected, and the blank rows are *hidden*.
Now, while everything is still selected,
<Data> <Sort>,
And choose your sort options, and SORT.

Then,
<Data> <Filter> <AutoFilter> *again* to de-activate the filter,
And you should now have all your blank rows back again, in between your
sorted data.
 
Top