There are many ways to insert and delete lines and columns in CSV mode.
- Simply double-clicking below the last line creates new lines. This only works if you are not editing a cell.
- Right-click on the left margin and select Insert Line Below.
- Select Insert | Empty Line Below. The default shortcut is Ctrl+Shift+Enter.
- Duplicate a line with Insert | Duplicate line (Ctrl+Shift+Y).
- Select a cell and drag the lower-right corner of the selection down to copy the cells to new lines. This feature is called Autofill.
- Change to Normal Mode and press Enter to create new lines, then change back to CSV Mode.
- Select one or multiple lines, right-click on the left margin and select Delete Lines.
- Select Edit | Advanced | Cut Line (Ctrl+L).
- Remove all empty lines with Edit | Advanced | Remove Empty Lines.
- Delete duplicate lines with Delete Duplicate Lines in the Sort toolbar.
- Change to Normal Mode, select a line and press Delete, then change back to CSV Mode.
- Double-click to the right of the right-most column.
- Right click in the column header and select Insert Column Right.
- Select CSV | Columns | Insert Column Right.
- Duplicate columns with CSV | Columns | Duplicate Columns.
- Select a cell and drag the lower right corner to the right to create new cells in new columns. This feature is called Autofill.
- Right-click in the column header above the column to delete and select Delete Columns.
- You can select multiple columns by click and dragging on the column header then delete those columns with the same command.
- Remove all empty columns with Remove Empty Columns (accessible through Quick Launch Ctrl+Shift+C).
- Hide a column by right-clicking in the column header and selecting Hide Columns. Unhide Columns is in the same menu.