Quickly split data into multiple worksheets based on selected column in Excel
Kutools for Excel
Supposing you have a worksheet that has data in columns A to G, the salesman’s name is in column A and you need to automatically split this data into multiple worksheets based on the column A in the same workbook. Each salesman will be splitted into a new worksheet. Kutools for Excel’s Split Date utility can quickly split data into multiple worksheets based on selected column in Excel.
Split data into multiple worksheets based on selected column
Split data into multiple worksheets based on every other rows
Recommended Productivity Tools for Excel/Office
Office Tab: Bring tabbed editing to Excel and other Office software, just like Chrome, Firefox and Safari.30-day Unlimited Free Trial
Kutools for Excel: 300 powerful features make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
Click Kutools Plus > Worksheet > Split Data (or Kutools Plus > Split Data). See screenshots:
![]() |
![]() |
![]() |
Split data into multiple worksheets based on selected column
Supposing you have a range data as shown in the below screenshot, and you want to quickly split this data into multiple worksheets based on the column A in a workbook by splitting each name in a new worksheet. For example, all Kelly will be splitted into the same worksheet. You can get it done as follows:
1. Please select the range which you want to split into multiple worksheet based on a column. Tip: If you have selected a range with header, please checked My data has headers option.
2. And then applying the utility by clicking Kutools Plus > Worksheet > Split Data. In the Split Date into Multiple Worksheets dialog box, please choose Specific column and then specify a column which you want to split data based on from the drop-down list.
3. Please specify the new worksheets name. You can use the Values of Column as the new worksheets name. You can also type in a Prefix or Suffix for the worksheets name.
4. Click OK to split data. See screenshot:
Each name in the column has been splitted into a new worksheet.
Split data into multiple worksheets based on every other rows
Supposing you have a range data as shown in the below screenshot, and you want to quickly split this data into multiple worksheets based on every other rows, for example, split every 5 rows of data into a new worksheet in the same workbook. You can get it donw as follows:
1. Please select the range that you want to split into multiple worksheets based on every 5 rows.
2. And then applying the utility by clicking Kutools Plus > Worksheet > Split Data. In the Split Date into Multiple Worksheets dialog box, please choose Fixed rows and then specify the rows number in the box.
3. Please specify the new worksheets name. You can use the Row Numbers as the new worksheets name. You can also type in a Prefix or Suffix for the worksheets name.
4. Click OK to split data. See screenshot:
Every 5 rows of this range has been spited into a new worksheet in the same workbook.
Demo: Quickly split data into multiple worksheets based on selected column in Excel
Kutools for Excel: with more than 200 handy Excel add-ins, free to try with no limitation in 60 days. Download and free trial Now!
The following tools can greatly save your time and money, which one is right for you?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: More than 300 Advanced Functions for Excel 2019, 2016, 2013, 2010, 2007 and Office 365.
Classic Menu for Office: Bring back familiar menus to Office 2007, 2010, 2013, 2016, 2019 and 365, as if it were Office 2000 and 2003.
Kutools for Excel
The functionality described above is just one of 300 powerful functions of Kutools for Excel.
Designed for Excel(Office) 2019, 2016, 2013, 2010, 2007 and Office 365. Free download and use for 60 days.