Generate All Possible Combinations of Certain Lists in Excel 365!!
Tags: kutoolsexceltutorial, stepstogenerateallpo, kutools
Published: 2020-10-06 08:54:37

---
title: Generate All Possible Combinations of Certain Lists in Excel 365!!
published: true
date: 2020-10-05 12:03:08 UTC
tags: KutoolsExcelTutorial,StepstoGenerateAllPo,Kutools
canonical_url: https://geekexcel.com/generate-all-possible-combinations-of-certain-lists-in-excel-365/
---

In this article, we are going to see how to **Generate All Possible Combinations of Certain Lists 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.
## Steps to Generate All Possible Combinations:

To generate all possible combinations of a list, please do as follows.

- Go to the **Kutools Tab, select** the **Insert option,** then **choose** the **List All Combinations** option from the menu.

![Select List All Combinations option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/1-4.png)<figcaption id="caption-attachment-15155">Select List All Combinations option</figcaption>

- It will open the **List All Combinations dialog box**.
- In that dialog box, you need to **choose** the **Value** option from the given drop-down list under the **Type** section.
- You can also **select** the **separator** option from the drop-down list if you want to add a separator.
- Next, you need to **click** the **browse** button under the **Text** section to **select the data** from which you want to find all combinations.

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

- You can also type the data in the text box directly but you need to separate each value with a comma ( **, ** ).
- Now, you need to **click** the **Add** button.

![List All Combinations dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/2-4.png)<figcaption id="caption-attachment-15156">List All Combinations dialog box</figcaption>

- **Repeat the above three steps** to add more lists of data as per your need.
- After finishing the above steps, you need to **click** the **OK** button. It will open a prompt box where you need to select the empty cell to display the output range.
- Hit the **OK** button.

![List All Combinations dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/List-All-Combinations-dialog-box.png)<figcaption id="caption-attachment-15158">List All Combinations dialog box</figcaption>

- Finally, all possible combinations of a given list of data have been generated and listed into the specified range.

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

## Closure:

In the above article, you can clearly understand the steps to **Generate All Possible Combinations of Certain Lists in Excel Office 365** using **Kutools. ** Drop your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Ahead:

- [How to Find Cells Which Contain Date Type Values Based on Criteria in Excel?](https://geekexcel.com/how-to-find-cells-which-contain-date-type-values-based-on-criteria-in-excel/)
- [Convert Numbers to Ordinal Numeral in Excel Office 365!!](https://geekexcel.com/convert-numbers-to-ordinal-numeral-in-excel-office-365/)