Why doesn't this sort?

[mayday1]

My data is thousands of rows from a txt file of a report that was many pages long. Each "page" has a header and footer and some rows were subtotals or other text. Column F has the data I want to sort, then I can just delete all the rows of trash that would be in contiguous rows.
But, if I sort right doing a right click, Sort, or by doing a sort from the menu, it only sorts the contiguous rows that have data in F - not the whole file.
How can I sort the whole mess?

 

[shg]

Select all of the data ...

 

[mayday1]

Duh.
Thanks