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.
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.