Elizabeth has attended:
Excel Advanced course
Excell Autofilter
Hello, I have been filtereing a table and changing the data in the collumn that has been filtered. Now I am unable to change the filter or clear the filter. the Data tab is all grayed out. I am also unable to remove the auto filters using the cntrl + shift + L hot keys, Excel will also not let me sort the table. Is this a bug? and is there a solution to it? Thanks in advance.
RE: Excell Autofilter
Hello Elizabeth
Sorry not to get back earlier. Yes you should be able to edit the filtered data and sort. It might be worth testing out if the same thing happends on a different computer. If not then you know it is to do with your version of Excel or your pc. Otherwise you can send you file to us by clicking the Upload button after posting a reply.
Hope that helps for now.
Regards
Doug Dunn
Best STL
