Spreadsheet Insert Menu

Inserts new rows or columns either before or after the current position. New rows are initially filled with missing values (*). New columns may be initialized to any constant value; in vector and scalar spreadsheets new columns represent new data structures.
Note: The short cut key Control+Shift+R allows you to duplicate the current row.

Row before Current Row

Inserts a new row immediately before the current row.

Row after Current Row

Inserts a new row immediately after the current row.

Multiple Rows

Inserts any number of new rows using the Spreadsheet Add Multiple Rows dialog.

Column before Current Column

Inserts a new column immediately before the current column using the Create a New Column. For vector spreadsheets you can set the column name and type.

Column after Current Column

Inserts a new column immediately after the current column using the using the Create a New Column. For vector spreadsheets you can set the column name and type.

Multiple Columns

Inserts any number of new columns using the Spreadsheet Add Multiple Columns dialog.

Clipboard

Inserts new rows and columns containing data from the Clipboard, starting at the current cell. Clipboard data is inserted in new rows below this point, from the current column and to the right; if there are insufficient columns to the right of the current cell new columns will be created as required.