New: ready-to-use spreadsheet templatesExplore the collection →

Google Sheets tutorials›Sort and filter›Filter by multiple values

Google Sheets · Verified tutorial

Filter by multiple values in Google Sheets

Create a filter on A1:B5 and show only rows whose Stage is Qualified or Contacted.

Verified by JosephineJuly 25, 2026About 60 seconds

Quick answer

Create a filter on A1:B5 and show only rows whose Stage is Qualified or Contacted.

Step-by-step

1

Open the practice sheetUse the example data shown below so the result is easy to check.

2

Filter by multiple valuesCreate a filter on A1:B5 and show only rows whose Stage is Qualified or Contacted.

3

Check the resultCompare the finished sheet with the expected result and correct the target range if needed.

Shortcut or faster method

Select the full target range first. This avoids repeating the same change cell by cell.

Expected result

A filter covers A1:B5.

Common mistake

Applying the change to more rows, columns, or cells than the task specifies.

Troubleshooting

Re-select A1:B5 and repeat the final action. A filter covers A1:B5.

Example spreadsheet data

This is the clean fixture used for the verified run.

Company	Stage
Acme	Qualified
Nova	New
Orbit	Contacted
Lumen	Qualified

Video transcript

Open the prepared Practice spreadsheet.
Open the practice sheet. Use the example data shown below so the result is easy to check.
Filter by multiple values. Create a filter on A1:B5 and show only rows whose Stage is Qualified or Contacted.
Check the result. Compare the finished sheet with the expected result and correct the target range if needed.
A filter covers A1:B5.