Sort by A to Z, Sort by Z to A, and Sort by Color.Ģ. Data Filter Based On Text Values – It is used when the cells contain TEXT values it has below mentioned Filtering Operators (Explained in example 1).Īpart from multiple filtering options in a text value, AutoFilter criteria provide the Sort options also relevant to a given column. There are three types of data filtering options:ġ. (keyboard shortcut – Control + Shift + L) Types of Data Filter in Excel
To activate the Excel data filter for any data in excel, select the entire data range or table range and click on the Filter button in the Data tab in the Excel ribbon.
In this scenario, the Data Filter helps out. If the table or range contains a huge number of datasets, it’s very difficult to find & extract the precise requested information or data.
Excel functions, formula, charts, formatting creating excel dashboard & others Uses of Data Filter in Excel