Angular Spreadsheet Filtering & Sorting
The Kendo UI for Angular Spreadsheet provides built-in filtering and sorting capabilities that allow you to organize and analyze your data effectively. You can filter data based on specific criteria and sort data in ascending or descending order, like in MS Excel.
The filtering and sorting features enable you to manage large datasets with ease. Along with the Data Validation tool, these features are accessible from the Data menu item in the Spreadsheet component.
Filtering Tool
To filter your data based on specific criteria:
-
Select the range of cells that contains the data you want to filter. You can select a single column (for example, column
B), multiple columns (for example,A1:G15), or specific rows. -
Navigate to the Data menu item in the toolbar and click the filter tool. Filter dropdown arrows appear in the header row of each column within the selected range.
-
Click the dropdown arrow in any column header to filter the values.
-
To clear the applied filtering, click the filter tool again.
Sorting Tool
To sort your data in ascending or descending order:
-
Select the range of cells that contains the data you want to sort. You can select a single column (for example, column
B), or specific rows within a column (for example,B2:B20). -
Navigate to the Data menu item in the toolbar and click the sort tool.
-
You can also use the sort options available in the filter dropdown menu of each column header.
Sorting from the filter dropdown menu sorts the entire selected range excluding the header row (where the dropdown arrow is located), just like in MS Excel.