Filter data in Sheets

Help Center

AI Assistant

Help Center AI Assistant is now available

Got questions about Lark? Use our AI chat to find the answers.

Click and hold to drag

Got It

Try Now

Filter data in Sheets

3 min read

Desktop

Mobile

I. Intro

You can use filters to quickly find the data you're looking for, regardless of the size of your data set.

II. Steps

Filter data

Select the data you want to filter and click Filter > Filter in the toolbar. The filter area will be marked by a blue border and Filter icons will appear in the first row. Click a Filter icon to open the filter pane.

250px|700px|reset

In the filter pane, you can select filter by value or filter by condition:

Option	Description	Image
Filter by value	Select the values you want to filter or enter keywords to search for the values. Separate keywords with a space, and click Confirm. To add new values to ones you've already selected, you can search for and select the new values, and then select Add to the current filter conditions. If this is not selected, only the new values will be filtered.	250px\|700px\|reset 250px\|700px\|reset
Filter by condition	You can also filter based on cell conditions, such as cell and text color, cell text and content, and more. Click Confirm once you've selected the conditions.	250px\|700px\|reset

You can turn on Filter only for me, and your filter results will not be visible to others and the results will be cleared once the page is refreshed. If you want to keep filter results, use filter view instead.

Modify filter range

In the top toolbar, click Filter > Remove filter, then select a new filter range and click Filter > Filter.

Clear filter results

Click the Filter icon on the right side of the cell, and then click Clear Filter in the lower-left corner of the filter panel. The filter results will be cleared, but the filter will remain.

Remove filter

Select any filtered cell and click Filter > Remove Filter.

III. Related

Use filter view in Sheets

IV. FAQs

Why is some data not filtered?

The data may not be in the filter range, which is marked with a blue border. Follow the steps above to modify the filter range to include the data you want to filter.

Why is filtering not always available?

Even if you have edit permission, tables set to Protected cannot be filtered. You can still click New filter view to filter the data (as shown in the image below). If you need full filter features, you can send a request to someone with manage permission for the spreadsheet to give you edit permission for the protected range, or you can request manage permission.

250px|700px|reset

Why can't others see my filter conditions?

If you only have view permission for the sheet, the filter results will only be visible to you and will be reset when you refresh the page. In addition, if you've added a new filter view, other users won't be able to see your filters either.

What are the differences between filter and filter view?

Filter and filter view serve different purposes:

Filter: Filter results are shown in the original sheet and are visible to all collaborators.

Filter view: A new view is created for your filter. In this view, filtered data will not affect the results displayed to other collaborators viewing the same sheet. Multiple collaborators can create their own filter views at the same time. For more details, see Use filter view in Sheets.