P Peako Nov 28, 2003 #1 After deleating some data in a column, the sort function and filter functions no longer work on my worksheet.
After deleating some data in a column, the sort function and filter functions no longer work on my worksheet.
D Dave Peterson Nov 29, 2003 #2 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.)
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.)