Please choose Specific column from the drop-down list in the Split Date into Multiple Worksheets dialogue box before choosing the column you wish to divide the data based on. Then, by selecting Home > Worksheet > Split Data, use the tool. To divide a range of data into numerous worksheets depending on a column, please choose the range first. Kelly, for instance, will be divided into one worksheet. If you have a range of data, like in the screenshot below, and wish to swiftly divide it into many worksheets based on column A in a workbook, separate each name into a new worksheet. Splitting Sheets using a selected column: This article contains steps to split important data in sheets, rows and columns. The Split Date tool in Kutools for Excel helps to split sheets in excel into separate files column selection and row selection. A fresh worksheet will be created for each student. Lets imagine The name of the student may be in column A of a worksheet that contains data, and you may need to automatically divide this data into numerous worksheets according on the name in column A. You can keep your data safe and assign particular individuals to manage different types of data by doing this. You might, for instance, divide a workbook into many separate Excel files and then give each file to a different person to manage. It could be necessary to divide a huge workbook into many Excel files by storing each worksheet as a distinct Excel file.