In general sense, filter is a method or tool that is used to show only certain amount of information from selected data and in Microsoft excel, filters can be used to narrow down the data in your worksheet and allowing you to view only the information you need.