Overview for Split Worksheet

Use Split Worksheet to divide the active worksheet into two or more new worksheets based on unique values or combinations of values in one or more grouping variables. Generally, Split Worksheet is most useful when it will create only a few new worksheets. Numerous worksheets can be cumbersome to manage.

For example, a medical researcher records the height and gender of a group of college students. The researcher splits the data by gender to create separate worksheets for the M (male) and F (female) data.

Original worksheet

C1	C2-T
Height	Gender
66	M
61	F
72	M
68	F
69	M
63	F

Worksheet: Gender = M

C1	C2-T
Height	Gender
66	M
72	M
69	M

Worksheet: Gender = F

C1	C2-T
Height	Gender
61	F
68	F
63	F

Where to find this command

To split the worksheet, choose Data > Split Worksheet.

When to use an alternate command

If you want to copy specified rows from the active worksheet to a new worksheet, use Subset Worksheet. You can specify the subset based on values in a column, formatted cells in a column, brushed points on a graph, and more.