# How do I filter columns and rows in the Gradebook?

The Filter menu allows the Gradebook to be filtered by assignment group, section, modules, student groups, assignment status, submission type, grading period (if applicable), and assignment due dates.

When a filter option is selected, the filter displays at the top of the Gradebook. Multiple filters can be used at the same time.

Filter options will apply to either Gradebook rows or columns. The option to filter columns affects all assignments within the filter. The options to filter rows affects all students within the filter. You can also [arrange columns](https://community.canvaslms.com/t5/Instructor-Guide/How-do-I-arrange-columns-in-the-Gradebook/ta-p/1018) within filter results.

<div id="bkmrk-embed-this-video"><iframe allowfullscreen="allowfullscreen" data-mce-fragment="1" frameborder="0" height="320px" src="https://community.instructuremedia.com/embed/2a2b1ab6-0f83-4f48-b761-c4c883198cac" title="Canvas Shorts: How do I filter columns and rows in the Gradebook?" width="560px"></iframe>

<button class="embed-button">Embed this Video</button></div>## Open Grades

<div data-step-uuid="b82f28dd-7130-433b-9b31-1f64695bc351" id="bkmrk-"><div data-step-uuid="b82f28dd-7130-433b-9b31-1f64695bc351"><div>![Open Grades](https://media.screensteps.com/image_assets/assets/002/766/984/original/a0823f10-c825-482a-ac0d-5301316cb74d.png)</div><div><div></div></div></div></div>In Course Navigation, click the **Grades** link.

## Search Students

<div data-step-uuid="a0884b0a-fdf5-42ba-b684-e9b3e904d16c" id="bkmrk--0"><div data-step-uuid="a0884b0a-fdf5-42ba-b684-e9b3e904d16c"><div>[![Search Students](https://media.screensteps.com/image_assets/assets/007/721/401/medium/0152fc9e-416c-45d6-9a20-cc8605bd9a3c.png)](https://media.screensteps.com/image_assets/assets/007/721/401/original/0152fc9e-416c-45d6-9a20-cc8605bd9a3c.png)</div><div><div></div></div></div></div>By default, the Gradebook shows all active students. To search for students by name or SIS ID, enter your search query in the **Search Students** field.

The Search Students field allows multiple student names to be filtered at the same time. Selecting a student filters the Gradebook to display only that student's row. If multiple students are selected, rows display for all selected students. Likewise, deselecting a student removes the student's row from the Gradebook view.

The Search Students field also respects Concluded and Inactive Enrollment options. If the Concluded Enrollment or Inactive Enrollment options are selected as filters, no Concluded or Inactive enrollments display in the Gradebook.

**Note:** Student name search results displays secondary information if more than one student has the same name in the course.

## Search Assignments

<div data-step-uuid="5d425d33-1276-47a4-9944-73ffabe6f9a6" id="bkmrk--1"><div data-step-uuid="5d425d33-1276-47a4-9944-73ffabe6f9a6"><div>[![Search Assignments](https://media.screensteps.com/image_assets/assets/007/721/403/medium/4c276ab6-c604-4df6-b399-4261377bde20.png)](https://media.screensteps.com/image_assets/assets/007/721/403/original/4c276ab6-c604-4df6-b399-4261377bde20.png)</div><div><div></div></div></div></div>By default, the Gradebook shows all assignments. To search for assignments, enter an assignment name in the **Search Assignments** field.

The Search Assignments field allows multiple assignment names to be filtered at the same time.

Selecting an assignment displays the assignment in a column closest to the student name. If multiple assignments are selected, the assignment columns display in the reverse order they are selected.

## Filter Gradebook

<div data-step-uuid="c3165234-f609-4952-be1e-9ee4884bb00b" id="bkmrk--2"><div data-step-uuid="c3165234-f609-4952-be1e-9ee4884bb00b"><div>![Filter Gradebook](https://media.screensteps.com/image_assets/assets/007/721/405/original/6d0121e8-901a-453f-b38c-6fe5953bb1a2.png)</div><div><div></div></div></div></div>Click the **Apply Filters** button \[1\]. Then you can either [create and manage filter presets](https://community.canvaslms.com/t5/Instructor-Guide/How-do-I-create-and-manage-filters-in-the-Gradebook/ta-p/577028) \[2\] or use the gradebook filters \[3\]. More than one filter can be applied at any time.

## View Modules

<div data-step-uuid="64332d6e-ab04-422c-9ba9-651f4ae90b22" id="bkmrk--3"><div data-step-uuid="64332d6e-ab04-422c-9ba9-651f4ae90b22"><div>![View Modules](https://media.screensteps.com/image_assets/assets/007/721/407/original/3e17a0c9-11f1-47cf-b717-0bbc3ca69fd2.png)</div><div><div></div></div></div></div>To filter by modules, click the **Modules** option \[1\]. Then select the module you want to display \[2\].

## View Grading Periods

<div data-step-uuid="37872983-fa7e-4eb5-be9f-550e0fd6d109" id="bkmrk--4"><div data-step-uuid="37872983-fa7e-4eb5-be9f-550e0fd6d109"><div>![View Grading Periods](https://media.screensteps.com/image_assets/assets/008/214/988/original/814b47ed-2b29-4a1c-9912-55fe8aa065c6.png)</div><div><div></div></div></div></div>When Multiple Grading Periods are enabled in a course, you can filter the Gradebook by grading period. To filter by grading period, click the **Grading Periods** option \[1\]. Then select the grading period you want to display \[2\].

## View Assignment Groups

<div data-step-uuid="f6e80e8d-ad0a-40ff-8791-4143afb9e652" id="bkmrk--5"><div data-step-uuid="f6e80e8d-ad0a-40ff-8791-4143afb9e652"><div>![View Assignment Groups](https://media.screensteps.com/image_assets/assets/007/721/413/original/afbff87c-8e9f-492d-a937-f318b7d7e707.png)</div><div><div></div></div></div></div>To filter by assignment group, click the **Assignment Groups** option \[1\]. Then select the assignment group you want to display \[2\].

## View Sections

<div data-step-uuid="dfc423cc-fc56-429f-8c50-4bff9e488978" id="bkmrk--6"><div data-step-uuid="dfc423cc-fc56-429f-8c50-4bff9e488978"><div>![View Sections](https://media.screensteps.com/image_assets/assets/007/744/080/original/ee4ff1c6-b7f3-4840-9207-28cce584dbf1.png)</div><div><div></div></div></div></div>To filter by section, click the **Sections** option \[1\]. Then select the section you want to display \[2\]. Course sections are displayed alphabetically.

**Note:** When a section filter is applied in the Gradebook, SpeedGrader also displays assignment submissions for the same section.

## View Student Groups

<div data-step-uuid="dd089ed1-68bd-4f59-9595-12e1deb8f950" id="bkmrk--7"><div data-step-uuid="dd089ed1-68bd-4f59-9595-12e1deb8f950"><div>![View Student Groups](https://media.screensteps.com/image_assets/assets/007/721/421/original/3755eced-da7f-4bac-a04d-1490d106b99a.png)</div><div><div></div></div></div></div>To filter by student groups, click the **Student Groups** option \[1\]. Then select the student group you want to display \[2\].

**Note:** If your course does not include student groups, the Student Groups option is not displayed.

## View Status

<div data-step-uuid="3072eb11-62ba-4266-b625-a19f1a902cfe" id="bkmrk--8"><div data-step-uuid="3072eb11-62ba-4266-b625-a19f1a902cfe"><div>![View Status](https://media.screensteps.com/image_assets/assets/007/721/424/original/046c313c-ca91-4531-9118-4dc333d7f0f0.png)</div><div><div></div></div></div></div>To filter by status, click the **Status** option \[1\]. Then select the status you want to display \[2\].

## View Submissions

<div data-step-uuid="5cdcb3a6-9c0f-4a30-a356-012fcdab9f3c" id="bkmrk--9"><div data-step-uuid="5cdcb3a6-9c0f-4a30-a356-012fcdab9f3c"><div>![View Submissions](https://media.screensteps.com/image_assets/assets/007/721/427/original/da812cb8-6a56-424c-b025-9fb8de021424.png)</div><div><div></div></div></div></div>To filter by submissions, click the **Submissions** option \[1\]. Then select the type of submissions

 you want to display \[2\].

## View Start and End Date

<div data-step-uuid="51d8d812-ef84-4f5d-a153-a3243ecca607" id="bkmrk--10"><div data-step-uuid="51d8d812-ef84-4f5d-a153-a3243ecca607"><div>![View Start and End Date](https://media.screensteps.com/image_assets/assets/007/744/083/original/3cbb7508-b96d-4e64-ba32-9810b26ddf1c.png)</div><div><div></div></div></div></div>To filter by start and end date, click the **Start &amp; End Date** option \[1\]. Then click in the **Start Date** and/or **End Date** fields and select dates \[2\]. Click the **Apply** button \[3\]. The Gradebook displays only assignments that have a due date at or beyond the start date and/or at or before the end date.

## View Filters

<div data-step-uuid="fb2a24ba-a009-4590-aa23-08ae1b7f28b3" id="bkmrk--11"><div data-step-uuid="fb2a24ba-a009-4590-aa23-08ae1b7f28b3"><div>[![View Filters](https://media.screensteps.com/image_assets/assets/008/184/327/medium/e96d5b1d-2de3-4eb3-9942-63e40d9996ba.png)](https://media.screensteps.com/image_assets/assets/008/184/327/original/e96d5b1d-2de3-4eb3-9942-63e40d9996ba.png)</div><div><div></div></div></div></div>View the selected filters \[1\].

You can manage selections directly from the filter option by clicking the **filter option** drop-down menu \[2\].

## Remove Filters

<div data-step-uuid="807836f4-c8cd-4fda-9802-4c7537bd7740" id="bkmrk--12"><div data-step-uuid="807836f4-c8cd-4fda-9802-4c7537bd7740"><div>[![Remove Filters](https://media.screensteps.com/image_assets/assets/008/184/329/medium/b6a6d94c-ab3f-487d-8853-2deb02a23db5.png)](https://media.screensteps.com/image_assets/assets/008/184/329/original/b6a6d94c-ab3f-487d-8853-2deb02a23db5.png)</div><div><div></div></div></div></div>To remove a filter, click the **filter option** drop-down menu \[1\] and click the **Remove Filter** option \[2\].

\[Content retrieved from [https://community.canvaslms.com/t5/Instructor-Guide/How-do-I-filter-columns-and-rows-in-the-Gradebook/ta-p/1016](https://community.canvaslms.com/t5/Instructor-Guide/How-do-I-filter-columns-and-rows-in-the-Gradebook/ta-p/1016)\]