Data will not sort

  • Thread starter Thread starter Peako
  • Start date Start date
P

Peako

After deleating some data in a column, the sort function
and filter functions no longer work on my worksheet.
 
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.)
 
Back
Top