OpenOffice/Calc 3/Working with and in cells/Inserting within a worksheet

The Insert command is used to add rows or columns to the worksheet to include additional categories of data. We use the menu bar to execute this command.

Insert a single row
In many cases, you can just enter the new data in the next available blank row. But sometimes you will want to position the new data in between rows that already contain data.

Insert one or more columns
Calc inserts new columns to the left of the selected column. Let's continue the example.

Insert more than one row
Use a technique similar to inserting 2 or more columns. Select the number of rows to be inserted below where the new rows will be added. The existing rows will be shifted downward.