Insert lines/columns

There are many ways to insert and delete lines and columns in CSV mode.

Insert lines

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.

Delete lines

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.

Insert Columns

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.

Delete columns

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.

← Freeze header Join CSV →