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 selectInsert Line Below.

• SelectInsert > Empty Line Below. The default shortcut is Ctrl+Shift+Enter.
• Duplicate a line withInsert > 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 calledAutofill.
• Change toNormal Mode and press Enter to create new lines, then change back toCSV Mode.

Delete lines

• Select one or multiple lines, right-click on the left margin and selectDelete Lines.
• SelectEdit > Advanced > Cut Line (Ctrl+L).
• Remove all empty lines withEdit > Advanced > Remove Empty Lines.
• Delete duplicate lines withDelete Duplicate Lines in theSort toolbar.

• Change toNormal Mode, select a line and press Delete, then change back toCSV Mode.

Insert Columns

• Double-click to the right of the right-most column.

• Right click in the column header and selectInsert Column Right.

• SelectCSV > Columns > Insert Column Right.
• Duplicate columns withCSV > 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 calledAutofill.

Delete columns

• Right-click in the column header above the column to delete and selectDelete 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 withRemove Empty Columns(accessible through Quick Launch Ctrl+Shift+C).
• Hide a column by right-clicking in the column header and selectingHide Columns.Unhide Columns is in the same menu.