Question

how do you create a custom list​

Answer 1

Answer:

Follow these steps to create your own custom list for sorting:

1. In a column of a worksheet, type the values to sort by. Arrange them in the order that you want to define the sort order—from top to bottom. For example:

Custom list example

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

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

Edit Custom Lists

4. In the Custom Lists box, click Import.

Answer 2

Answer:

Create your own custom list

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