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.
  • Click in the worksheet and choose Editor > Subset Worksheet > Custom Subset.
  • 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 and choose Editor > Subset Worksheet > Exclude Rows with Formatted Cells, or Editor > Subset Worksheet > Include Rows with Formatted Cells.

By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy