Sort with blank rows between data rows

S

Sheila

I have a worksheet with blank rows between each row containing data. Is
there a way to sort this worksheet while retaining the rows between the data?
Right now when I sort, all the blank rows end up below the data.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sort data with blank rows dividing data 5
Deleting blank rows 4
Deleting blank rows with formulas in them 7
How do I delete blank rows (rows alternate data, blank, data, etc 2
Inserting blank rows 3
Deleting Multiple Blank Rows 6
gang remove blank rows 13
Combining data from multiple rows 2

Top