Finding rows

There are three ways to find rows. Search jumps between matches and keeps every row. Filter hides the rows that don’t match. Unique values lets you pick a value from a list.

Search: jump to a match

Press /, type, and press Enter to jump to the first row in the current column that contains it. Case doesn’t matter. n goes to the next match and N to the previous one. Esc clears the search.

Filter: keep only matching rows

Press f on a column and type a condition. The table updates as you type. Enter keeps the filter and Esc throws it away.

Some details:

• >, <, >= and <= only work on number columns.
• Plain text is case-sensitive: lap won’t find Laptop. Put (?i) in front to ignore case: (?i)lap.
• Plain text is actually a regular expression, so ^North means “starts with North”. A . matches any character, which is why 3.5 also finds 305.

Filters add up. Filter region to = North, then move to amount and filter > 500, and you see northern orders over 500. F removes every filter.

Unique values: pick from a list

u lists every distinct value in the current column, the most common first, with a count next to each. Move with j / k and press Enter to filter the table to that value. Esc closes the list.

Long list? Press / and type to narrow it, then ↑ / ↓ and Enter as before. Esc stops typing.

It’s the easy way to filter when you don’t know exactly how a value is spelled. Columns with more than 500 distinct values show the top 500, and the title says [top 500].