When you click a Filter option or when you click on Custom Filter that appears at the end of the Filter options, Custom AutoFilter dialog box appears, wherein you can customize your filtering options. For example, if the column contains numbers, when you click on the arrow next to the column header, Number Filter Options appear. Each AutoFilter has filter options based on the type of data you have in that column. AutoFilter is represented by the arrow next to column header. In a table, the column headers are automatically tagged to filters, known as AutoFilters.
Text filters if the column you selected contains text.You can Filter data in a Range, table or PivotTable. This is a quick way to display only the information that is needed by you. Filtering allows you to extract data that meets the defined criteria from a given Range or table.
