98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excell Autofilter
Excell Autofilter
Resolved · Low Priority · Version 2007
Thu 24 Jan 2013, 10:29Delegate Elizabeth said...
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.
Mon 28 Jan 2013, 14:22Trainer Doug said...
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
Mon 4 Feb 2013: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Moving or Copying Sheets Between Workbooks in Excel 2010Here's how to move or copy sheets between workbooks in Excel 2010: |
