How to create and fill new custom lists quickly in Excel?

You can apply Excel's Custom List feature to create a new custom list, and then fill the new custom list horizontally or vertically as you need easily. Please do as follows:

1. Click File > Options to open the Excel Options dialog box.

2. In the Excel Options dialog box, click Advanced button at left bar, scroll to the General section and click the Edit Custom List button. See screenshot:

Note: If you are using the Excel 2007, please click the Office Button > Excel Options > Popular, and then you will get the Edit Custom Lists button in the Top options for working with Excel section.

With the above method, you need to enter the first value and then drag the fill handle to fill the cells, but here, I introduce a quicker tool for you. With Kutools for Excel’s Fill Custom Lists utility, you can create your own custom list and fill the values in a selected range vertically or horizontally without inputting the first value.

1. Click Kutools > Insert Tools > Fill Custom Lists, and then click the Edit List button in the opening Fill Custom Lists dialog box. See screenshot:

2. Now in the opening Options dialog box, please select the NEW LIST item in the Custom lists box; type each item of the custom list into the List entries box, and then click the Add button and OK button successively. See screenshot:

Notes:

(1) You need type the list of values separated by Enter button or comma.

(2) If the values exist in current workbook, you can click the Browse button behind the Import list from cells box to select the cells, and click Import button.

3. Now you get back to the Fill Custom Lists dialog box, please do as below:

(1) Select the first cell of destination range where you will random fill the new custom list;

(2) In the Fill Custom Lists dialog box, please select the Fill vertically cell after cell option or Fill Horizontally cell after cell option from the Fill order drop down list;

(3) Click to highlight the new custom list;

(4) Click the Fill Range button.

And then the new custom list is filled into the destination range vertically or horizontally as you configured See left screenshot:

Kutools for Excel - Supercharge Excel with over 300 essential tools. Enjoy permanently free AI features! Get It Now

Create and randomly fill new custom lists without duplicates

Apart from creating a custom list and then fill the list ordinarily, Kutools for Excel’s Insert Random Data utility provides Excel users another workaround: create a custom list from excel cell data, and then randomly fill the new custom list in another column easily.

Kutools for Excel - Packed with over 300 essential tools for Excel. Enjoy permanently free AI features! Download now!

1. Click Kutools > Insert > Insert Random Data. See left screenshot:

2. In the opening Insert Random Data dialog box, please click the Add button on the Custom list tab; In the next popping up Kutools for Excel dialog box, please click the  Browse button; and in the second Kutools for Excel dialog box, please select the list of cells which you will create as a custom list, and click the OK > OK buttons. See below screenshot:

And now you get back to the Insert Random Data dialog box with the new custom list selected.

3. Please select the range where you will randomly fill this new custom list, check the Unique Values option and click the Ok button successively in the Insert Random Data dialog box. See screenshot: