Skip to main content

Sorting data

Sorting data by a column

To sort spreadsheet data by a column, take the following steps:

1. Right-click the header of the column you want to sort the data by

2. Choose Sort -> Sort A to Z or Sort Z to A

DHTMLX Spreadsheet column header context menu with Sort A to Z and Sort Z to A options

or

1. Select the necessary column by clicking on its header

2. Go to: Data -> Sort -> Sort A to Z or Sort Z to A in the menu

DHTMLX Spreadsheet Data menu with the Sort submenu showing Sort A to Z and Sort Z to A

Sorting data by a range

To sort spreadsheet data by a separate range, take the following steps:

1. Select a range of cells in the column you want to sort the data by

2. Choose one of the two actions:

  • Right-click a cell in the selected range and choose Sort -> Sort A to Z or Sort Z to A

DHTMLX Spreadsheet context menu on a selected range with the Sort submenu

  • Or go to: Data -> Sort -> Sort A to Z or Sort Z to A in the menu

DHTMLX Spreadsheet Data menu with the Sort submenu for sorting a selected cell range