sorting issue

[Pat]

Hi,

When a range of columns are highlighted and a sort is performed on only one
column empty cells above the sort display first. How can this be prevented.
I know when there is data in any of the other column but not on the column
being sorted this will happen.

Any thoughts?
Pat

 

[Dave Peterson]

Are you sure the cells are really empty?

They don't contain spaces or even formulas that evaluate to "". (Even formulas
converted to values that returned "")?