We help IT Professionals succeed at work.

Excel 2016 - Edit Items in Custom Sort Level

153 Views
Last Modified: 2017-03-08
Hey Everyone,

Feeling a little silly here...recently I created a custom sort level as shown below. I even edited it even more recently. However, I now need to add another value to it ("Assigned"), but cannot remember how to edit it. :(

Excel 2016 Custom Sort Level
Please advise per the above. Thanks.
Comment
Watch Question

ShumsManaging Director/Excel VBA Developer
CERTIFIED EXPERT
Distinguished Expert 2018

Commented:
Hi Stephen,

For creating your own custom list follow this link :Sort data using a custom list
ShumsManaging Director/Excel VBA Developer
CERTIFIED EXPERT
Distinguished Expert 2018

Commented:
Here is another link, which may help youExcel 2013: Sorting Data
Even it is for Excel 2013, but it will work same in Excel 2016
Test your restores, not your backups...
CERTIFIED EXPERT
Expert of the Year 2019
Top Expert 2016
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
Stephen KairysTechnical Writer - Consultant

Author

Commented:
@Bill - Thank you! I was missing the step of clicking on "Custom List".

@Shums - Thanks for your help. However, since Bill provided explicit directions, I had to give him the points, as I don't have time to read through a link that contains other info as well.

Steve
Bill PrewTest your restores, not your backups...
CERTIFIED EXPERT
Expert of the Year 2019
Top Expert 2016

Commented:
Welcome, glad that helped.

~bp