Feature Summary
The filtering feature is used to display specific data rows based on conditions, helping team members quickly locate and view required data in collaborative mode, thereby improving data collaboration efficiency.
Feature Description
| Feature Dimension | Description |
|---|---|
| Membership Restriction | No membership restriction |
| Version Restriction | No version restriction |
Operation Steps
Enable Filtering
Feature Entry
"Home" tab → "Filter" button
- Select any cell within the data area (or select the complete data table to be filtered)
- Click the "Filter" button in the Home tab
- A filter dropdown arrow icon will appear in each column header
- Or use the shortcut key Ctrl + Shift + L to quickly enable filtering
Filter Data by Condition
Feature Entry
Click the dropdown arrow in the column header
- Click the dropdown arrow of the target column
- Select filter conditions in the pop-up panel:
- Filter by Option: Check the options to display
- Filter by Color: Filter by cell background color
- Filter by Condition: Equals, greater than, less than, between, and so on.
- After checking the target conditions, the table will only display rows that meet the conditions
Use Search Box for Quick Filtering
Feature Entry
Click the column header dropdown arrow → Search box
- Click the dropdown arrow of the target column
- Enter keywords in the search box
- The system will automatically filter out data items containing the keyword
- Check or uncheck the corresponding items, then click confirm
Clear Filtering
Feature Entry
"Home" tab → "Filter" button (click again to cancel) / Column dropdown arrow → Clear Filter
- To clear the filter condition of a specific column, click the dropdown arrow of that column and select "Clear Filter"
- To clear all filter conditions, click the "Filter" button again to turn off filter mode
- Or use the shortcut key Ctrl + Shift + L to quickly toggle the filter status
Frequently Asked Questions
Q1: Does the filter I set in collaborative mode affect other collaborators?
- Solution: Disable the option "Filter visible to everyone" in the filter box; this filter will not affect other collaborators
Q2: How to reapply all filter conditions?
- Solution: "Home" tab → "Filter" button dropdown arrow → Reapply all filter conditions.
Q3: Why are filter dropdown arrows not displayed for some columns?
- Solution: Check if the data area contains empty rows or columns, as empty rows/columns will truncate the filter range. Ensure the data area is continuous, or check "Home" tab → "Filter" button dropdown arrow → Include data after empty rows in filtering.
Notes
- Filtering does not delete data; it only hides rows that do not meet the conditions
- Before using advanced filtering, a criteria range must be set; multi-column combined condition filtering is supported
- Filtering can also be enabled/disabled in the Data tab