|Binding rows with headers
Bind rows with headers to lock the row number and always display one beside the other.
Expand and collapse columns to better fit the content.
Make pre-defined calculations and display the results in Handsontable.
Add a menu to the heading to enable additional operations for the columns.
|Export to file
Export data to a flat file like CSV or a string.
Display rows that meet your criteria and hide the rest.
Display the header label in a tooltip.
Hide specific columns and show the rest.
Hide specific rows and show the rest.
|Multiple column sorting
|Sort data in ascending or descending order throughout multiple columns.
Create a nested, hierarchical structure of headers to get your data into groups.
Exclude specific rows from the rendering process so they won't be displayed.
|Decide where the content is placed within the cell or a range of cells.
|Choose one of the suggested options while typing or entering a custom value.
|Add a checkbox to a cell to indicate binary choices.
|Provide an additional note about the cell to help better understand its content.
|Define how specific cells are formatted depending on their values.
|Invoke a shortcut menu to choose an action related to the selected object.
|Apply custom border style around cells or range of cells.
|Insert and remove column or row using custom action buttons.
|Display HTML content in a cell or header.
|Control what values can be entered into a cell.
|Use a date picker to select a date.
|Disable cell editing
|Make cell non-editable without changing its appearance and behaviour.
|Drag the fill handle (a square in the bottom right corner of the cell) to fill cells with data series.
|Create an advanced dropdown list of choices in a cell.
|Fixed rows and columns
|Define which rows or columns are visible while scrolling down or across the table.
|Create freeze columns to keep them visible while scrolling.
|Use Handsontable itself as a custom cell editor.
|Indicate the entire active column or row.
|Change the text of the UI for the purpose of translating it to specific languages.
|Display cells across multiple rows or columns.
|Drag rows or columns to swap them within the table.
|Type a custom number format in a cell.
|Use asterisks to mask the value in a cell.
|Pre-populating new rows
|Create empty cells with predefined types or values
|Lock the cell or a range of cells to disallow altering them.
|Drag the sizing handle to change the size of column or row.
|Use native scrollbars to navigate within the table.
|Search for values
|Search through the content with the search field.
|Create a simple dropdown list of choices in a cell.
|Sort data in ascending or descending order throughout the column.
|Allow columns to the parent container width.