How to Create Worksheets From a List of Worksheet Names in Excel 365?
Tags: createworksheetsfrom, kutoolsexceltutorial, kutools
Published: 2020-12-02 09:52:30

---
title: How to Create Worksheets From a List of Worksheet Names in Excel 365?
published: true
date: 2020-12-02 05:39:15 UTC
tags: CreateWorksheetsfrom,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/how-to-create-worksheets-from-a-list-of-worksheet-names-in-excel-365/
---

In this article, we will describe how to **Create Worksheets from a List of Worksheet Names in Excel Office 365** using **Kutools.** 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 Worksheets from a List of Excel Default Names:

In the Excel workbook, the default worksheet names displayed as **Sheet1, Sheet2, Sheet3,** and so on. If you want to create multiple worksheets with these default names, Kutools will help you to do that with a few steps.

- [**Open the Workbook**](https://geekexcel.com/open-a-workbook-using-shortcut-in-excel-365/) where you need to create multiple [sheets](https://geekexcel.com/how-to-use-excel-sheets-function-in-office-365-with-examples/).
- Go to the **Kutools Plus Tab, select** the **Worksheet** option, then **choose** the **Create Sequence Worksheets** option from the menu.

![Kutools Plus Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/1-3.png)<figcaption id="caption-attachment-18431">Kutools Plus Tab</figcaption>

- Then, it will display the **Create Sequence Worksheets Dialog box**.
- **Base Worksheet –** You need to **select one worksheet** that you want to create sequence worksheets based on.
- **The number of create –** You need to **specify the number** of worksheets that you want to create.
- **Sheet names based on – Check** the **Excel Default Name** option from this section.
- Finally, **click** the **OK** button.

![Click OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Click-OK-button.png)<figcaption id="caption-attachment-18432">Click OK button</figcaption>

- You can see that the sequence worksheets with default sheet names have been created in the workbook as shown in the below image.

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

## Steps to Create Worksheets from a List of Month/Day Names:

To create worksheets from a list of month or day names in Excel, follow the below steps.

- You need to [**open the workbook**](https://geekexcel.com/open-a-workbook-using-shortcut-in-excel-365/).
- On the **Kutools Plus Tab, select** the **Worksheet** option, then **choose** the **Create Sequence Worksheets** option from the menu.

![Kutools Plus Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/1-3.png)<figcaption id="caption-attachment-18431">Kutools Plus Tab</figcaption>

- Then, it will open the **Create Sequence Worksheets Dialog box**.
- **Base Worksheet –** You need to **select one worksheet** that you want to create sequence worksheets based on.
- **Sheet names based on – **** Select **the** Custom Lists** option under this section.
- Then in the expanded dialog, you need to **click** the **day** or **month names** from the right list box that you want.
- Now, the **number of creating worksheets** will be displayed automatically.
- At last, you need to **click** the **OK** button.

![Create Sequence Worksheets Dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/2-3.png)<figcaption id="caption-attachment-18437">Create Sequence Worksheets Dialog box</figcaption>

- You will get the result as shown in the below screenshot.

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

## Create Worksheets from a List of series Numbers:

You can create worksheets from a list of series numbers by doing the below steps.

- First, you need to [**open the workbook**](https://geekexcel.com/open-a-workbook-using-shortcut-in-excel-365/) where you want to create worksheets.
- Go to the **Kutools Plus Tab, select** the **Worksheet** option, then **choose** the **Create Sequence Worksheets** option from the menu.

![Kutools Plus Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/1-3.png)<figcaption id="caption-attachment-18431">Kutools Plus Tab</figcaption>

- It will display the **Create Sequence Worksheets Dialog box**.
- **Base Worksheet –** You need to **select one worksheet** that you want to create sequence worksheets based on.
- **Sheet names based on – **** Select **the** Sequence Numbers** option under this section.
- In the expanded dialog, you need to **set the sequential numbers** and you need to **add** the **prefix/suffix** for the numbers as you need.
- **The number of create –** You need to **specify the number** of worksheets that you want to create.
- After completing the above steps, you need to **click** the **OK** button.

![Create Sequence Worksheets Dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/4-2.png)<figcaption id="caption-attachment-18439">Create Sequence Worksheets Dialog box</figcaption>

- Finally, you will get the following sequence worksheets named with series numbers as shown in the below image.

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

## Steps to Create Worksheets from a Custom list:

To create worksheets from a custom list in Excel, follow the below steps.

- You need to [**open the workbook**](https://geekexcel.com/open-a-workbook-using-shortcut-in-excel-365/).
- On the **Kutools Plus Tab, select** the **Worksheet** option, then **choose** the **Create Sequence Worksheets** option from the menu.

![Kutools Plus Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/1-3.png)<figcaption id="caption-attachment-18431">Kutools Plus Tab</figcaption>

- Then, it will open the **Create Sequence Worksheets Dialog box**.
- **Base Worksheet –** You need to **select one worksheet** that you want to create sequence worksheets based on.
- **Sheet names based on – **** Select **the** Custom Lists** option under this section.
- In the expanded dialog box, you need to click ![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/shot-button1.png) button. The **Create List Dialog Box** will pop-out, here you can **create your own custom list** data.
- In that dialog box, you need to click ![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/shot-button2.png) button to add the name into the below list box. You need to repeat it to add other names.
- After inserting the sheet names, you need to **click** the **Add** button.

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

- Now, you need to **select the custom list** from the right list box that you have created.
- You can see the number of creating worksheets will be displayed automatically.
- Then, **click** the **OK** button.

![Click OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/6-2.png)<figcaption id="caption-attachment-18442">Click OK button</figcaption>

- Your customized names of worksheets have been created in a new workbook.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/7-1.png)<figcaption id="caption-attachment-18443">Result</figcaption>

## Create Worksheets from a List of Cell Values:

If you want to create worksheets from a list of cell values, then follow the below instructions.

- You need to **select the range** that you want to create worksheets.

![Select a range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Select-a-range.png)<figcaption id="caption-attachment-18444">Select a range</figcaption>

- Go to the **Kutools Plus Tab, select** the **Worksheet** option, then **choose** the **Create Sequence Worksheets** option from the menu.

![Kutools Plus Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/1-3.png)<figcaption id="caption-attachment-18431">Kutools Plus Tab</figcaption>

- It will display the **Create Sequence Worksheets Dialog box**.
- **Base Worksheet –** You need to **select one worksheet** that you want to create sequence worksheets based on.
- **Sheet names based on –** You need to **check** the **Data in**  **a range** option under this section.
- The number of creating worksheets will be displayed automatically.
- Finally, you need to **click** the **OK** button.

![Create Sequence Worksheets Dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/8-1.png)<figcaption id="caption-attachment-18445">Create Sequence Worksheets Dialog box</figcaption>

- You can see that the new worksheets have been created with the cell values in a new workbook as shown in the below screenshot.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/9-1.png)<figcaption id="caption-attachment-18446">Result</figcaption>

### Note:

- **Worksheet color option –** You can **check this option** in the **Create Lists** Dialog box to specify the color for the sheet tabs.

![Worksheet color](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/10-1.png)<figcaption id="caption-attachment-18447">Worksheet color</figcaption>

- You will get the result as shown in the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/11-1.png)<figcaption id="caption-attachment-18448">Result</figcaption>

## Bottom-Line:

In the above article, you can easily understand the steps to **Create Worksheets from a List of Worksheet Names in Excel Office 365** using **Kutools. ** Share your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Keep Reading:

- [Split/Save Each Worksheet of One Workbook as Separate Excel/Txt/Csv/Pdf Files in Excel 365!!](https://geekexcel.com/split-save-each-worksheet-of-one-workbook-as-separate-excel-txt-csv-pdf-files-in-excel-365/)
- [How to Rename Multiple Worksheets in Excel Office 365?](https://geekexcel.com/how-to-rename-multiple-worksheets-in-excel-office-365/)