SOLVED

SP list - Sort choice selections alphabetically when you edit a column?

%3CLINGO-SUB%20id%3D%22lingo-sub-2054596%22%20slang%3D%22en-US%22%3ESP%20list%20-%20Sort%20choice%20selections%20alphabetically%20when%20you%20edit%20a%20column%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2054596%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20choice%20column%20with%20about%2030%20items.%26nbsp%3B%20I%20just%20added%20a%20couple%20of%20more%20items%20but%20now%20they%20are%20at%20the%20bottom%20of%20the%20list%20and%20I%20don't%20see%20how%20to%20sort%20them.%26nbsp%3B%20In%20the%20old%20days%2C%20everything%20was%20in%20one%20text%20box%20and%20I%20could%20just%20easily%20add%20them%20in%20the%20correct%20location.%26nbsp%3B%20That%20no%20longer%20works.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can't%20just%20copy%20them%20all%20and%20sort%20in%20excel%20as%20needed%20either.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2054596%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2056481%22%20slang%3D%22en-US%22%3ERe%3A%20SP%20list%20-%20Sort%20choice%20selections%20alphabetically%20when%20you%20edit%20a%20column%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2056481%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F325149%22%20target%3D%22_blank%22%3E%40Bryan123%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20you%20know%2C%20SharePoint%20will%20not%20automatically%20order%20the%20choice%20selections%20and%20you%20need%20to%20sort%20them%20in%20excel%2C%20then%20paste%20the%20sorted%20choices%20again%20to%20choice%20column%20settings.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20do%20this%20follow%20below%20steps%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3COL%3E%3CLI%3EGo%20to%20your%20SharePoint%20list.%3C%2FLI%3E%3CLI%3EClick%20on%20Settings%20(gear)%20icon%20from%20top%20right%20corner%20and%20select%26nbsp%3B%3CSTRONG%3EList%20settings%3C%2FSTRONG%3E.%3C%2FLI%3E%3CLI%3EScroll%20the%20page%20below%20to%26nbsp%3B%3CSTRONG%3EColumns%3C%2FSTRONG%3E%20section%20and%20select%20your%20choice%20column%20by%20clicking%20on%20column%20name.%3C%2FLI%3E%3CLI%3ECopy%20everything%20from%26nbsp%3B%3CSTRONG%3EType%20each%20choice%20on%20a%20separate%20line%3C%2FSTRONG%3E%20textbox.%3C%2FLI%3E%3CLI%3EPaste%20it%20into%20Excel%20file%20--%26gt%3B%20sort%20the%20choices%20--%26gt%3B%20copy%20sorted%20choices%20and%20paste%20in%26nbsp%3B%3CSTRONG%3EType%20each%20choice%20on%20a%20separate%20line%3C%2FSTRONG%3E%20textbox.%3C%2FLI%3E%3CLI%3EClick%26nbsp%3B%3CSTRONG%3EOK%3C%2FSTRONG%3E%20to%20save%20column%20settings.%3C%2FLI%3E%3C%2FOL%3E%3CP%3E%3CSTRONG%3EAdditional%20Reference%3C%2FSTRONG%3E%3A%26nbsp%3B%3CA%20title%3D%22Sorting%20Choices%20in%20Choice%20Field%22%20href%3D%22https%3A%2F%2Fsharepoint.stackexchange.com%2Fquestions%2F266023%2Fsorting-choices-in-choice-field%2F266028%23266028%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3ESorting%20Choices%20in%20Choice%20Field%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CHR%20%2F%3E%3CP%3EPlease%20click%20%3CSTRONG%3EMark%20as%20Best%20Response%3C%2FSTRONG%3E%20if%20my%20post%20helped%20you%20to%20solve%20your%20issue.%20This%20will%20help%20others%20to%20find%20the%20correct%20solution%20easily.%20It%20also%20closes%20the%20item.%20If%20the%20post%20was%20useful%20in%20other%20ways%2C%20please%20consider%20giving%20it%20%3CSTRONG%3ELike%3C%2FSTRONG%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2074235%22%20slang%3D%22en-US%22%3ERe%3A%20SP%20list%20-%20Sort%20choice%20selections%20alphabetically%20when%20you%20edit%20a%20column%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2074235%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F373269%22%20target%3D%22_blank%22%3E%40ganeshsanap%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDidn't%20think%20about%20doing%20it%20from%20the%20settings.%26nbsp%3B%20I%20was%20trying%20to%20do%20it%20from%20the%20list%20itself%20but%20editing%20the%20column.%20You%20use%20to%20be%20able%20to%20do%20it%20that%20way.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2345722%22%20slang%3D%22en-US%22%3ERe%3A%20SP%20list%20-%20Sort%20choice%20selections%20alphabetically%20when%20you%20edit%20a%20column%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2345722%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20method%20of%20placing%20items%20in%20alphabetical%20worked%20fantastic%3B%20thanks%20for%20the%20suggestion!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2345765%22%20slang%3D%22en-US%22%3ERe%3A%20SP%20list%20-%20Sort%20choice%20selections%20alphabetically%20when%20you%20edit%20a%20column%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2345765%22%20slang%3D%22en-US%22%3E%3CP%3EYou're%20welcome%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1051099%22%20target%3D%22_blank%22%3E%40dmdanleaf%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGlad%20it%20helped%20you!%3C%2FP%3E%3CHR%20%2F%3E%3CP%3EPlease%20click%26nbsp%3B%3CSTRONG%3EMark%20as%20Best%20Response%3C%2FSTRONG%3E%26nbsp%3B%26amp%3B%20%3CSTRONG%3ELike%3C%2FSTRONG%3E%20if%20my%20post%20helped%20you%20to%20solve%20your%20issue.%20This%20will%20help%20others%20to%20find%20the%20correct%20solution%20easily.%20It%20also%20closes%20the%20item.%20If%20the%20post%20was%20useful%20in%20other%20ways%2C%20please%20consider%20giving%20it%20%3CSTRONG%3ELike%3C%2FSTRONG%3E.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

I have a choice column with about 30 items.  I just added a couple of more items but now they are at the bottom of the list and I don't see how to sort them.  In the old days, everything was in one text box and I could just easily add them in the correct location.  That no longer works.

 

I can't just copy them all and sort in excel as needed either.

4 Replies
best response confirmed by Bryan123 (Contributor)
Solution

@Bryan123 

 

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:

 

  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 ReferenceSorting 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 

 

Didn't think about doing it from the settings.  I was trying to do it from the list itself but editing the column. You use to be able to do it that way.

 

Thank you!

This method of placing items in alphabetical worked fantastic; thanks for the suggestion!

You're welcome @dmdanleaf 

 

Glad it helped you!


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.