How can we help?

Docs | Filter data in Sheets

Add, edit, or delete a filter

You can exclude unwanted content or data by using the filter function. You are able to see all your data again when you turn off your filters.

Filters are only available on our desktop version.

1. Select the data you want to filter.

2. Click Filter to add a filter.

1. Click the filter icon on top of the data you require.

2. Edit options in the filter panel:

Filter by condition: choose from a list of conditions, and you can filter information by color, number or text. For example, constrain the data which is less than a certain number, or constrain the text that contains a certain letter or a phrase.
Filter by values: uncheck any data that you want to hide. If you want to choose all data, click Select all.
Search: search for data points by typing in the search box. For example, typing "A" will shorten your list to the names that start with "A".

3. Click Confirm and the filter will take effect.

Click Filter again to cancel the filter.

Updated today

Updated yesterday

Updated N days ago

Updated on MM/DD/YYYY

Was this article helpful?

For questions on how to use the product or to report bugs, please contact support