Data will not sort

[Peako]

After deleating some data in a column, the sort function
and filter functions no longer work on my worksheet.

 

[Dave Peterson]

Make sure you select the whole range first, then do reapply the
Data|filter|autofilter (remove any existing filter first if you have to).

Excel sometimes guesses incorrectly where your data stops. I don't like to
trust it at all.

(Same kind of thing happens with sorting.)