Filter
Use quick filtering options
You can specify filtering conditions manually or use quick filter options. Quick filter options are filtering conditions for the current column name. The conditions depend on the value in the current cell.
Right-click a cell and navigate to Filter by.
Select an option that you want to apply.
Filter rows when you run a search
You can filter rows when you run a search Ctrl+F on the table.
Press Ctrl+F and select Filter Rows.
Start typing your search query (for example,
John
).
Filter table data with a query
You can filter data in a table by writing a query in the Row Filter field.
If the Row Filter is not available, click the settings icon () and select Row Filter.
In the Row Filter field, type your query. The query syntax is the same as in the
WHERE
clause but without theWHERE
keyword. For example,first_name LIKE 'JOH%' AND last_name LIKE 'CA%'
.You can use SQL wildcards within the
LIKE
expressions. For example, the percent sign%
for zero or more characters and underscore_
for a single character.Press Enter. To reset the filter, click the clear icon (), or delete the contents of the Row Filter field and pressEnter.