Overview for Subset Worksheet

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

For example, a medical researcher who is studying obesity collects BMI and body fat percentages for adolescent girls. The researcher subsets the data to create a worksheet that contains only BMI values of 25 or greater.

Original worksheet

C1	C2
BMI	%Fat
24.1308	39.1
23.8650	33.6
33.5654	46.0
29.1450	38.9
...	...

Subsetted worksheet: BMI >= 25

C1	C2
BMI	%Fat
33.5654	46.0
29.1450	38.9
...	...

Where to find this command

To subset the worksheet, do one of the following:

Choose Data > Subset Worksheet.
Right-click in the worksheet and choose Subset Worksheet > Custom Subset.

When to use an alternate command

If you want to quickly subset a worksheet based on formatted cells (for example, cells that have red shading) in a column, click in the column, then right-click and choose Subset Worksheet > Exclude Rows with Formatted Cells, or Subset Worksheet > Include Rows with Formatted Cells.