Moving around a file — Trusty CSV User Guide

Scrolling sideways

Files with many columns are wider than the window. To scroll sideways:

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 View › Appearance › Sticky First Column, 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.

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.