Insert - Remove

Command:

Edit

Insert

Rows

Columns

Remove

Rows

Columns

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, select the corresponding command in the Edit menu.

Examples:

When the cell pointer is located in row 20 and you select the command Insert row in the 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 select the command Remove column in the 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.