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

Google Sheets tutorials›Errors›Filter not working

Google Sheets · Verified tutorial

Filter not working in Google Sheets

Create a basic filter that covers the complete table A1:B5. Leave all rows visible.

Verified by JosephineJuly 25, 2026About 75 seconds

Quick answer

Create a basic filter that covers the complete table A1:B5. Leave all rows visible.

Step-by-step

1

Select the targetCreate a basic filter that covers the complete table A1:B5.

2

Apply the changeLeave all rows visible.

Shortcut or faster method

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

Expected result

A basic filter covers A1:B5.

Common mistake

Starting with the wrong cell or range selected.

Troubleshooting

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

Example spreadsheet data

This is the clean fixture used for the verified run.

Task	Status
Draft brief	Open
Review copy	In progress
Publish page	Done
Send report	Open

Video transcript

Open the prepared Filter repair spreadsheet.
Select the target. Create a basic filter that covers the complete table A1:B5.
Apply the change. Leave all rows visible.
A basic filter covers A1:B5.