Avatar of Stephen Kairys
Stephen KairysFlag for United States of America

asked on 

Excel 2016 - Edit Items in Custom Sort Level

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. :(

User generated image
Please advise per the above. Thanks.
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Bill Prew
Avatar of Shums Faruk
Shums Faruk
Flag of India image

Hi Stephen,

For creating your own custom list follow this link :Sort data using a custom list
Avatar of Shums Faruk
Shums Faruk
Flag of India image

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
ASKER CERTIFIED SOLUTION
Avatar of Bill Prew
Bill Prew

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of Stephen Kairys

ASKER

@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
Avatar of Bill Prew
Bill Prew

Welcome, glad that helped.

~bp
Microsoft Excel
Microsoft Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo