HomeMenu CommandsRows menuView menu
  CSVEditor 2 > Menu Commands Index

Columns menu

Here you can edit spreadsheet columns. Some of these menu functions are also available in the document window's toolbar. Some of these menu functions are even available in the context menu for columns.

Add Column

This function adds a new column to the right end of the document.

Insert Columns

Use this function to insert one or more columns into the document, optionally at its beginning (left), its end (right), or in front of or behind the currently selected column. A form sheet will be shown where you define the number of columns to be inserted and where.

Remove Selected Column(s)

This menu entry can only be selected when at least one column of the document has been selected. After a (suppressable) security alert question the selected columns will be removed. This delete function is undoable.

Note: When you press [Alt] while the Columns menu is opened, the menu item text changes to Remove Deselected Column(s). Using the alternate menu item acts accordingly and removes all deselected columns.

Merge Selected Columns

This menu entry can only be selected when at least two columns of the document have been selected. A form sheet will be opened, where you define which columns should be merged and how.

Edit Title

This menu item correlates with a double-click on a column title. A tiny form will be shown, where you can change the header title for this column.

Alignment

Here you can choose whether the cell contents of the selected column(s) should be left, centered or right aligned.

Hint: When you save the document into a CSV file, this information will be lost because CSV files are pure text files without any formatting information.

Transformations

This menu entry offers various options to change cell contents of the selected column(s). You can change all text of the cell contents to upper or lower case, capitalize them or trim spaces in front of and behind the cell contents.

Fill

Use this powerful feature to fill CSV tables quickly with contents. A form sheet will be opened where you can define text or numbers to be filled into the data field cells. The form is self-descriptive.

Clear

This function clears all cell contents of the selected column(s) without any security alert. This delete function is undoable.

Adjust All Columns Widths

This function adjusts all columns widths to their current cell contents. Here the column title contents are not respected.


HomeMenu CommandsRows menuView menu