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.