The basic Excel filter (also known as the Excel Autofilter) allows you to view specific rows in an Excel spreadsheet while hiding the other rows in the worksheet. When a filter is added to the header row of a spreadsheet, a drop-down menu appears on each cell of the header row. This provides you with a number of filter options that can be used to specify which rows of the spreadsheet are to be displayed.
