Question

What are the ways to create custom lists​

Answer 1

Explanation:

Create a custom list

For Excel 2010 and later, click File > Options > Advanced > General > Edit Custom Lists.

For Excel 2007, click the Microsoft Office Button. ...

In the Custom Lists box, click NEW LIST, and then type the entries in the List entries box, beginning with the first entry. ...

When the list is complete, click Add.

Mark brainliest

Answer 2

Answer:

In a column of a worksheet, type the values to sort by. ...

Select all of the cells in that list, and then click File > Options > Advanced.

Scroll way down to the General section and click Edit Custom Lists...

In the Custom Lists box, click Import.