|
In response to
"stis/ms excel 2007 help needed: how do i sort cells in a column so ..."
by
reluctantcynic (en treo)
|
You'd have to sort by another column first - Excel won't sort blank cells on their own.
Posted by
JaxSean (aka JaxSean)
Feb 17 '09, 07:50
|
or you could create a new column next to the column you want to sort, and put a function in it like:
=IF(a1 = "", 0, 1)
which is basically saying if there's no data in the cell, make the new column cell a 0, if there is data, put a 1.
Then sort by the new column ascending (so your 0's show up top).
|