Excel Autofilter Usability

In my opinion one of the coolest features in Excel is the Auto-filter. It works quite well when using 1 drop down filter but when combining more than 1 it can become quite hairy. In my experiences not many people use multiple filters so it doesn’t particularly matter. The thing that really get’s on my nerves however is the custom widget that is used for the actual drop down. It doesn’t behave like ever other drop down box. Your scroll wheel doesn’t work and if you type into it, it always matches the first letter rather than adding to your search string. I have a sneaking suspicion this is a remnant from an early version of Excel.

1,662 thoughts on “Excel Autofilter Usability

  1. I?????????ll right away grasp your rss as I can not in finding your e-mail subscription hyperlink or newsletter service. Do you ave any? Please allow me recognize in order that I could subscribe. Thanks.

  2. Pretty nice post. I just stumbled upon your blog and wished to say that I have really enjoyed browsing your blog posts. After all I will be subscribing to your feed and I hope you write again soon!

Leave a Reply

Your email address will not be published. Required fields are marked *