editing

Moving, copying and deleting rows

Move a row up or down, copy it, or delete it, with a key, and always the whole row.

Keys Command
Alt+↑⌥↑ / Alt+↓⌥↓ Move Row Up / Move Row Down
Alt+Shift+↑⌥⇧↑ / Alt+Shift+↓⌥⇧↓ Copy Row Up / Copy Row Down
Ctrl+Shift+K⇧⌘K Delete Row

They act on the row of the cursor, or on every row the selection touches, and they are also in the Rows menu.

They take rows, not lines: a row with a value that has line breaks in it moves, copies or goes away whole, with all its lines, so its quotes are never split. In a file without such values a row is a line, and they work as in any code editor.

Delete Row leaves the cursor on the row that comes after, at the same place on the screen, so that pressing it again deletes the next one.

Rows › Delete Rows Above the Cursor deletes every row above the cursor’s, so that it is the first row of the file: for a title or notes above the table (see Lines above the table).

The header row stays first

When the first row is the header, it stays at the top: moving rows never moves it, and never moves another row above it. You can still copy it, or delete it with Ctrl+Shift+K⇧⌘K.

To put the rows in order by a column instead of by hand, see Sorting rows.