Keyboard shortcuts

Press ← or → to navigate between chapters

Press S or / to search in the book

Press ? to show this help

Press Esc to hide this help

Find in the table

/ (or f) finds a cell that matches text, a regex or letters in order, and moves the cursor to it without changing the rows. Ctrl+G keeps only the rows that match.

Type what to find. As you type, matching cells in the rows already loaded light up, and the prompt says how many are on screen (3 on screen); this reads no more data. Press Enter and the cursor, row and column, goes to the first matching cell at or after its row. The cell stays highlighted until the cursor leaves it. Find reads the view as it stands (query, filters, sort, the columns shown) and never changes it.

KeyAction
/ or fFind. The prompt holds the last pattern, selected, so typing replaces it
nNext match after the cursor’s cell, left to right then down
NPrevious match before the cursor’s cell
EscWhile a find reads, stop it and the n N typed behind it; the cursor stays where it was. Otherwise clear the find

n and N start from the cursor’s cell, as in vim: move the column cursor along a found row and n finds the next match to its right. After the last match n wraps to the first, and the footer says Wrapped to the top; N wraps the other way. Each n typed while a find is reading runs in turn, so five presses move five matches. Esc stops them all.

In the prompt

KeyAction
EnterGo to the first match at or after the cursor’s row; on an empty field, clear the find
Ctrl+GKeep only the rows that match, as a filter
Ctrl+RRegex on or off
Ctrl+TLetters in order on or off
Ctrl+LOnly the column cursor’s column, or every column shown
↑ ↓Earlier patterns
EscCancel

Case is ignored unless the pattern has a capital letter: oslo finds Oslo, Oslo does not find oslo. In a regex, an escape such as \S is not a capital. Each value is matched as text, so 05-17 finds a date and 2.5 a number; binary and nested columns are skipped.

MatchPatternFinds
TextchickenCrispy Chicken Sandwich
Regex (Ctrl+R)^ChickChick-n-Strips, not Crispy Chicken
Letters in order (Ctrl+T)chknChick-n-Strips, Crispy Chicken: the letters need not be adjacent; spaces in the pattern are ignored

Keep the matches

Ctrl+G in the prompt keeps only the rows with a match, as a filter. The footer shows it (has "chicken", has /^Chick/, name has letters "chkn" when limited to a column), and so does the Sort & Filter sidebar, where you remove it like any other filter; R resets the view. The find stays in effect, so n steps through the matches in the rows kept.

While a find is in effect the footer offers n/N and Esc, and its status line shows the pattern: find "chicken", or find /^ch/ for a regex, find ~chkn for letters in order, with in name when it is limited to a column. match 3 follows when the finds so far stepped from the top of the view to the cursor, so the match’s number is known. Nothing counts all the matches: a find reads only as far as the next one.

Large data

A find starts in the rows already read. Past them, it reads on through the view a window at a time, and the footer counts the rows read on a line of its own (rows 1,200,000 / 3,475,226, with a bar when the view’s rows are counted). Esc or Ctrl+O stops it. A filtered view, a CSV or an NDJSON file cannot skip to a window, so there N reads the rows before the cursor in one pass, and n from deep in the view reads windows at least as large as the rows above them. A find follows the order on screen, even in a sorted view or a SQL result, so n never skips or repeats a row.