Change the order of choices in a formated choice column

%3CLINGO-SUB%20id%3D%22lingo-sub-1906298%22%20slang%3D%22en-US%22%3EChange%20the%20order%20of%20choices%20in%20a%20formated%20choice%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1906298%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20I%20reorder%20choice%20values%20in%20a%20formatted%20choice%20column%20in%20a%20SharePoint%20list%3F%20In%20the%20default%20UI%20(edit%20column)%20there%20is%20no%20way%20to%20reorder%20them.%20I%20tried%20to%20reorder%20them%20via%20the%20list%20settings%2C%20then%20it%20works%20until%20you%20change%20anything%20in%20the%20default%20ui%20(edit%20column)%20again.%3CBR%20%2F%3EWhat%20is%20the%20best%20way%20to%20sort%20that%20values%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1906298%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1909127%22%20slang%3D%22en-US%22%3ERe%3A%20Change%20the%20order%20of%20choices%20in%20a%20formated%20choice%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1909127%22%20slang%3D%22en-US%22%3EThat's%20strange...changing%20the%20order%20through%20the%20list%20settings%20should%20work%3C%2FLINGO-BODY%3E
Occasional Contributor

How do I reorder choice values in a formatted choice column in a SharePoint list? In the default UI (edit column) there is no way to reorder them. I tried to reorder them via the list settings, then it works until you change anything in the default ui (edit column) again.
What is the best way to sort that values?

3 Replies
That's strange...changing the order through the list settings should work

@Markus Meusburger I am having the same issue.  If you need to add another choice in the list there is no way to reorder them in a logical order.  I think currently you have to manually do it and delete/re-enter. 

@Markus Meusburger@BGibbons ,

 

You are right, currently there is no way to reorder the choices in modern experience. Also, SharePoint will not automatically order the choice selections. So, you need to sort them in excel, then paste the sorted choices again to choice column settings (classic experience).

 

To do this follow below steps:

  1. Go to your SharePoint list.
  2. Click on Settings (gear) icon from top right corner and select List settings.
  3. Scroll the page below to Columns section and select your choice column by clicking on column name.
  4. Copy everything from Type each choice on a separate line textbox.
  5. Paste it into Excel file --> sort the choices --> copy sorted choices and paste in Type each choice on a separate line textbox.
  6. Click OK to save column settings.

Additional References

  1. SP list - Sort choice selections alphabetically when you edit a column? 
  2. 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.