---
title: "Excluding rows of data"
slug: "excluding-rows-of-data"
updated: 2025-09-10T15:13:00Z
published: 2025-09-10T15:13:00Z
canonical: "userguide.dataclassroom.com/excluding-rows-of-data"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://userguide.dataclassroom.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Excluding rows of data

Is this right page for you?If you are looking to exclude or filter **entire categorical variables**, check out [this page](/v1/docs/customizing-categorical-variables) for how to do so.

Sometimes you want to exclude some **specific rows** of data in your dataset. This might be because:

- There is something wrong with the data (you can see from the values that it's been typed in wrong, like if a person's height was set to 12 feet, but you don't know what the right value should have been).
- You want to show just a subset of your data on the graph (you collected data from three classes, but only want to show for two of them)

## How do I do it?

In the **TABLE tab,** click the **Excluded** checkbox at the **end of each row**:

![](https://cdn.document360.io/62f8f41e-e041-42c4-b9bc-8ae1eb45d064/Images/Documentation/image-1677420082646.png)

Excluded rows are removed from all functions in the tool - graphing, calculations, everything. It's like they weren't there.

### Excluding many rows with similar values

Three options to exclude:

![](https://cdn.document360.io/62f8f41e-e041-42c4-b9bc-8ae1eb45d064/Images/Documentation/Untitled%20drawing-16.png)

Use a **Filter** to set the exclude checkboxes dependent on the contents of one or more columns. [See this article for details](/v1/docs/filtering-rows-of-data).

![](https://cdn.document360.io/62f8f41e-e041-42c4-b9bc-8ae1eb45d064/Images/Documentation/Untitled%20drawing-17.png)

**Exclude by value** **of a Categorical** column. Open the gear icon for the column and use the Exclude tools there. Read more [specifics here.](/v1/docs/customizing-categorical-variables)

![](https://cdn.document360.io/62f8f41e-e041-42c4-b9bc-8ae1eb45d064/Images/Documentation/Untitled%20drawing-18.png)

Select all the rows in a range (drag down the left row# column to select the rows, or click on the first row and then shift-click on the final row) and then click any Exclude checkbox in the range to exclude or de-exclude them all at once.