Moving around a file
Scrolling sideways, going to a line, a row or a column by name, and jumping from value to value.
Scrolling sideways
Files with many columns are wider than the window. To scroll sideways:
- Hold Shift⇧ and turn the mouse wheel.
- Or turn the wheel with the pointer over the horizontal scroll bar, at the bottom of the file: there the wheel alone scrolls sideways, as in most Windows programs.
- A touchpad, or a wheel that tilts, scrolls sideways by itself.
- In Chrome and Edge on Windows, a click with the middle button starts scrolling in the direction you then move the mouse, in any direction; another click stops it.
Keeping the first column in sight
The first column is often the one that says what each row is: an id, a name. Scroll sideways and it is gone. With , it stays at the left of the window, beside the line numbers, while the other columns pass under it, the way the header’s names stay at the top when you scroll down. Its number stays over it in the column bar, and so does its name once the header row is out of sight.
- It is the column as it is drawn in its place: the same colour, the same alignment, the same … on a long value.
- A click on one of its cells puts the cursor in that cell, and the window scrolls back to the left edge, where you edit it as always.
- The cursor is never left under it. When you move left with the arrow keys, or press Home, the row comes out from under the first column as the cursor gets there.
- A first column wider than a third of the window is cut there, so that it never takes the room of everything else.
- It needs : without aligned columns there is no column to keep in its place.
The grey rows that a filter leaves at the end of the file, and the grey lines of a comparison, are not rows of the file: they scroll whole.
It is off until you turn it on, and then it is on for every file.
Going to a line or a row
Ctrl+G⌘G asks for a line number and goes there. Type # before the number to go to a row instead: #250 is the 250th row of data, counting from the one after the header and taking a value with line breaks as one row, however many lines it spans. A click on the row in the status bar (Row 11 of 1,978) opens it with the # already typed.
Going to a column
Ctrl+Shift+O⇧⌘O lists the columns by name, with their number and whether they have long values. Type part of a name to find it, and Enter puts the cursor in that column, on the same row.
From value to value
Ctrl+Alt+→⌥⌘→ and Ctrl+Alt+←⌥⌘← move the cursor to the start of the next or previous value, across rows. With several cursors, every one of them moves.
The rest are the keys of any text editor: Ctrl+Home⌘Home and Ctrl+End⌘End go to the start and the end of the file, Home and End to the start and end of the line, PgUp and PgDn a window up or down. The header names pinned at the top never hide the cursor.
Problems in the file
F8 and Shift+F8⇧F8 go to the next and the previous problem of the file: a row with too few values, a stray space, a quote that never closes… See Quality Check.