Just a thought....
Instead of inserting new rows just to add space,
select the data range and increase the row heights
<format<row<height...double the current height.
That creates the same effect while making it easier to navigate through the
data list and adding no complications to sorting.
Is that something you can work with?
***********
Regards,
Ron
XL2002, WinXP
"rbul1" wrote:
Can I retain blank rows within an Excel worksheet sort?
I have a worksheet containing single rows of data alternated with blank cell
rows for readability.
I would like to do a data sort on the name column and retain the alternate
blank rows, is this possible?
Thanks, Bob