Adding headers and sorting with headers made no difference. When I sort, the
blank rows still show up at the top!!

Another clue - the blank rows look blank and there does not appear to be
anything in the cells - no values, no equations. If I highlight those blank
cells and hit delete (enen though there is apparently nothing there to
delete!!), the subsequent sort puts the blank lines at the bottom as it
should.

What is being deleted from the empty cells?

"Tevuna" wrote:

1) Add headers. And if Excel doesn't automatically detect..
2) Data, Sort, data has headers