In this tutorial, you will learn how to filter data in Excel in different ways: how to create filters for text values, numbers and dates, how to use filter with search, and how to filter by color or by selected cell's value. You will also learn how to remove filters, and how to fix Excel AutoFilter not working. Filtering in excel - not all options display in drop down list. (unless there is something hidden that I do not know about). I have found work-arounds for the problem by searching google for answers to similar problems. I have also spoken to my employee's IT HelpDesk. I will explain the work-arounds I have found below.