Insert - Remove

Command:

Edit

Insert

Rows

Columns

Remove

Rows

Columns

Description

Allows to insert or remove one or more blank rows or columns in the spreadsheet.

To insert or remove the spreadsheet row or column where the cell pointer is located, use the corresponding command in the Edit menu.

Examples:

When the cell pointer is located in row 20 and you click Insert row on the Edit menu, then all rows starting with row 20 will be moved down and a new row will be inserted at this position. So row 20 will be moved to row 21, row 21 to 22, etc., and row 20 will be empty.
When the cell pointer is located in column B and you click Remove column on the Edit menu, then column B will be removed and all columns starting with column C will be moved to the left. So the data in column B will be lost, and column C will be moved to column B, column D to C, etc.