Many commands can be finetuned to operate on rows which are 'selected'.
||selects/toggles/unselects current row|
||selects/toggles/unselects all rows|
||selects/unselects rows matching regex in current column|
||selects/unselects rows matching regex in any visible column|
||selects rows matching current cell in current column|
||selects rows matching this row in all visible column|
An example usage follows.
ton the rows to filter.
gd to delete the selected rows.
" to open a duplicate sheet with references to the selected rows. Edits performed within the duplicate sheet will also propagate to the source sheet.
gz" to open a duplicate sheet with copies of the selected rows. Any changes will not affect the source sheet.
||move cursor row down/up|
||move cursor row all the way to the bottom/top of sheet|
yto delete/yank the row and move it to the clipboard.
Pto paste the row after/before current row.
ton those rows to select them.
gyto cut/yank all selected rows to the clipboard.
Pto paste those rows after/before current row.
||sorts ascending/descending by current column|
||sorts ascending/descending by all key columns|
[to sort the column from highest to lowest.
]to sort the column chronologically.
!on those columns to designate them as key columns.