Search data
Press Ctrl+F to search data. Additional controls appear once search gets focus.
Click on the gear icon to control whether the matching rows get selected or filtered automatically as the search string changes.
Shortcuts
| Ctrl+F | Activate search |
| Up | Previous matching cell |
| Down | Next matching cell |
| Esc | Close search |
| Enter or Alt+S | Filter matching rows |
| Shift+Enter or Alt+F | Filter matching rows |
Examples
See search patterns for all supported queries
| > 5 | all numeric cells with value > 5 |
| age > 21 | "age" column > 21 |
| disease contains disorder | "disease" column contains "disorder" substring |
| disease ends with disorder | "disease" column ends with "disorder" |
| after 9/21/2019 | All dates after 9/21/2019 |
| 2014-2020 | All dates with years 2014-2020 |
| open yesterday | "open" column: yesterday |
See also: