Forum Discussion
SP list - Sort choice selections alphabetically when you edit a column?
As you know, SharePoint will not automatically order the choice selections and you need to sort them in excel, then paste the sorted choices again to choice column settings.
To do this follow below steps:
- Go to your SharePoint list.
- Click on Settings (gear) icon from top right corner and select List settings.
- Scroll the page below to Columns section and select your choice column by clicking on column name.
- Copy everything from Type each choice on a separate line textbox.
- Paste it into Excel file --> sort the choices --> copy sorted choices and paste in Type each choice on a separate line textbox.
- Click OK to save column settings.
Additional Reference: Sorting Choices in Choice Field
Please click Mark as Best Response if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
ganeshsanap Does this remove the formatting (colors) of the choices?
BeckyH13 If you have already created a choice column with all the choices from modern experience & just changing the sort order of choices from column settings (not adding any new choice option), color formatting will not be removed.
If you are adding any new choice from (classic experience) column settings page, that will not be considered in column/color formatting JSON.
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
- Thank you!
BeckyH13 You're welcome! Glad it helped you.
Please consider giving a Like if my post helped you in any way.