Question

delete or edit a custom list​

Answer 1

Delete a custom list

Follow the previous instructions for displaying the Edit Custom Lists dialog.

In the Custom Lists box, choose the list that you want to delete, and then click Delete.

Create a custom list

1. For Excel 2010 and later, click File > Options > Advanced > General > Edit Custom Lists.
2. For Excel 2007, click the Microsoft Office Button. ...
3. In the Custom Lists box, click NEW LIST, and then type the entries in the List entries box, beginning with the first entry.
4. When the list is complete, click Add.