How to Create Custom Lists and Fill Cells with them in Excel 365?
Tags: kutoolsexceltutorial, stepstocreatecustoml, kutools
Published: 2020-10-13 11:59:58

---
title: How to Create Custom Lists and Fill Cells with them in Excel 365?
published: true
date: 2020-10-13 10:37:25 UTC
tags: KutoolsExcelTutorial,StepstoCreateCustomL,Kutools
canonical_url: https://geekexcel.com/how-to-create-custom-lists-and-fill-cells-with-them-in-excel-365/
---

In this article, we are going to see how to **Create Custom Lists and Fill Cells with them in Excel Office 365** using **Kutools.** Let’s get into this article!! Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.

## Create Custom Lists and Fill Cells:

If you want to create custom lists and fill cells with them, follow the below steps.

- You need to select the range that you want to fill with the custom lists.
- Go to the **Kutools Tab, select** the **Insert** option, **choose** the **Fill Custom Lists** option.

![Choose the Fill Custom lists option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Choose-the-Fill-Custom-lists-option.png)<figcaption id="caption-attachment-15633">Choose the Fill Custom lists option</figcaption>

- It will open the **Fill Custom Lists Dialog Box**.
- In that dialog box, you need to **click** the **Edit list** option to create the new custom list values.

![Fill Custom Lists Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Fill-Custom-Lists-Dialog-Box.png)<figcaption id="caption-attachment-15634">Fill Custom Lists Dialog Box</figcaption>

- Now, it will display the **Custom Lists dialog box**.
- You need to **click** the **New List** option under the **Custom lists** section.
- Then, **enter** the **custom list values** ( **separate by comma** ) one by one under the **List entries** box.
- Now, **click** the **Add button** to add them to the Custom lists.

![Custom Lists Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Custom-Lists-Dialog-Box.png)<figcaption id="caption-attachment-15635">Custom Lists Dialog Box</figcaption>

- Now, you can see that the new list is added to the custom list as shown in the below image.

![New list is added](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/New-list-is-added.png)<figcaption id="caption-attachment-15636">A new list</figcaption>

- **Hit** the **OK** button to go back to the **Fill Custom Lists dialog box**.
- Then, select the newly created list values and **choose** the **Fill vertically cell after cell** option from the drop-down list under the **Fill Order** section.
- You need to **click** the **Fill Range** option.

![Click the Fill Range option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Click-the-Fill-Range-option.png)<figcaption id="caption-attachment-15637">Click the Fill Range option</figcaption>

- At last, the selected data range has been filled into the cells in vertical order as shown in the below screenshot.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Output-27.png)<figcaption id="caption-attachment-15641">Output</figcaption>

### Note:

- If you want to **import multiple rows and columns of data** , the **Import Custom Lists dialog box** will be opened after **clicking** the **Import** button.
- If you **check** the **Columns** option, it will import the selected range as lists by columns.
- You can also **check** the **Rows** option to import the selected range as lists by rows.

![Choose the Columns option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Choose-the-Columns-option.png)<figcaption id="caption-attachment-15646">Choose the Columns option</figcaption>

- After clicking the **OK** button, it will show the list as shown in the below example image.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Example-18.png)<figcaption id="caption-attachment-15647">Example</figcaption>

## Closure:

In this article, you can clearly learn the steps to **Create Custom Lists and Fill Cells with them in Excel Office 365** using **Kutools.** Kindly, share your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### See Also:

- [Save and Export Charts, Graphs, as JPEG Image Files in Excel](https://geekexcel.com/save-and-export-charts-graphs-as-jpeg-image-files-in-excel-365/)
- [Reverse Text String or Words Order in Excel ](https://geekexcel.com/reverse-text-string-or-words-order-in-excel-office-365/)