# Sort Dialog

Learn how to effectively sort rows or columns using the Sort dialog in Spread Designer. Choose what to sort and the order of sorting with ease.

## Content

You can sort rows or columns using the **Sort** dialog of the Spread Designer. To open this dialog, from the **Data** menu, select the Sort icon. In the **Sort** dialog, as shown in the figure, select what to sort and the order of sorting. When done, click **OK**.
![image](https://cdn.mescius.io/document-site-files/images/e31400f0-03a3-4cfc-a80d-08d62bed05a8/image.e3636e.png?width=650)
This dialog has the following items:

| **Item** | **Description** |
| ---- | ----------- |
| Add Level | Add another column to sort by |
| Delete Level | Delete a column to sort by. |
| Copy Level | Copy a column to sort by. |
| Column | In the **Sort by** box, select the first column that you want to sort. |
| Sort On | Select the type of sort. Do one of the following:<ul><li>To sort by text, number, or date and time, select **Cell Values**.</li><li>To sort by format, select **Cell Color**, **Font Color**, or **Cell Icon**.</li></ul> |
| Order | Select **A to Z** or **Z to A**. |

For more information on the sort settings, refer to [Managing Data on a Sheet](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-cell/spwin-usedata) in the Developer’s Guide.
For more information on how to do this in code, refer to the [SortInfo](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.SortInfo.html) class.

## See Also

[Cell Type Dialog](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDCellTypesDialog)
[Conditional Formatting Dialog](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDconditionalDialog)
[Custom File Options Dialog](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDCustomFileOptions)
[Go To Cell Dialog](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDGoToCell)
[Row Height or Column Width Dialog](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDHeightWidth)
[Row or Column Insert or Delete Dialogs](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDInsertDelete)
[Shape Properties Dialog](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/sdshapepropsdialog)
[Shape Shadow Properties Dialog](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDShapeShadowDialog)
[Sheet Settings Dialog](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDSheetDialog)
[Sheet Print Settings Dialog](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDPrintDialog)
[Spread Settings Dialog](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDSpreadDialog)
[Unhide Specific Row or Column Dialogs](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDUnhideDialog)
[Zoom Dialog](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDZoomDialog)
[BarCode Tab](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDCellTypesDialog/SD-celltype-barcode)
[Color Picker Tab](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDCellTypesDialog/sd-celltype-colorpicker)
[Name Manager Dialog](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDNameManager)