Split Data Into Multiple Worksheets Based On Selected Column in Excel!!
Tags: kutoolsexceltutorial, splitdataintomultipl, kutools
Published: 2020-11-16 07:31:54

---
title: Split Data Into Multiple Worksheets Based On Selected Column in Excel!!
published: true
date: 2020-11-16 06:42:17 UTC
tags: KutoolsExcelTutorial,SplitDataIntoMultipl,Kutools
canonical_url: https://geekexcel.com/split-data-into-multiple-worksheets-based-on-selected-column-in-excel/
---

In this article, we are going to see how to **Split Data Into Multiple Worksheets Based On Selected Column 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.
## **Split Data Into Multiple Worksheets Based On Selected Column:**

To split data into multiple worksheets based on the selected columns in Excel, do the following steps.

- Let’s consider an example to make it clear.
- In the below image, you can see the name list in **column A** , and we are going to split the data into multiple based on each name.
- First, you need to **select the column** that you want to split.

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

- Go to the **Kutools Plus Tab** , **select** the **Worksheet** option, **choose** the **Split Data** option.

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

- It will open the **Split Date into Multiple Worksheets** dialog box.
- **Specific column –** You need to **select** the **column** that you want to split.
- **New worksheets name –** You can use the **Values of Column** as the new worksheet’s name.
- You can also type the **Prefix** or **Suffix** for the worksheet’s name.

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

- At last, **click** the **OK** button to split the data as shown in the below image.
- Here, you can see that each name in the column has been split into a new worksheet.

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

## **Split Data Into Multiple Worksheets Based On Rows Number:**

If you want to split data into multiple worksheets based on rows number, then follow the below instructions.

- In the below image, we have shown the list of **names** in **Column A** , and we will **split every 4 rows**.
- To do that, **select the range** that you want to split into multiple worksheets.

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

- On the **Kutools Plus Tab** , **select** the **Worksheet** option, then **choose** the **Split Data** option.

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

- Then, it will display the **Split Date into Multiple Worksheets** dialog box.
- **Fixed rows –** You need to **specify** the **rows number** using the given drop-down box.
- **New worksheets name –** You can use the **Row Numbers**  as the new worksheets name.
- You can also type the **Prefix** or **Suffix** for the worksheet’s name.

![Split Date into Multiple Worksheets dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/5-12.png)<figcaption id="caption-attachment-17292">Split Date into Multiple Worksheets dialog box</figcaption>

- Then, **click** the **OK** button to split the data as shown in the below image.
- Here, you can see that **every 4 rows** of this range have been split into a new worksheet in the same workbook.

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

## **Conclusion:**

In this article, you can easily understand the steps to **Split Data Into Multiple Worksheets Based On Selected Column in Excel Office 365** using **Kutools. ** Share your **feedback** in the comment box. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Ahead:

- [How to Filter Cells by Uppercase or Lowercase in Excel?](https://geekexcel.com/how-to-filter-cells-by-uppercase-or-lowercase-in-excel/)
- [How to Filter Cells with Strikethrough in a Specific Column with One Click?](https://geekexcel.com/how-to-filter-cells-with-strikethrough-in-a-specific-column-with-one-click/)