Sorting in Excel

T

tbtelhill

I need to sort rows of data so the blank rows come at the top then all other
items alphabetically.
How do I do this?
They come at the bottom in the default sort order whether Ascending or
Descending is selected and I can't see a way of overriding this or changing
the default sort order.
 
J

Joel

sorting descending order should bring blankcells to the top of the worksheet.
If you want the rest of the data in ascending order your have to sort again
selecting the rows after the blnak rows of data.

Make sure when you are sorting the blank cells to the top that you select
the rows with the blank data in the sort selection.
 
G

Gord Dibben

Joel

My Excel 2003 and 2007 sort the blanks to the bottom.

To my recollection Excel has always sorted blanks to the bottom.


Gord Dibben MS Excel MVP
 

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

Top