How to insert or add row in OpenOffice Spreadsheet?
There are three options to insert a single row,
Step 1: Click on the cell where you want to add a new row.
Step 2: Right click → Insert
Step3: Select Entire Row then click OK
The row will be inserted before the selected cell.
Step 1: Click on the cell where you want to insert a new row.
Step 2: In the home tab, select Insert→ Rows
Option 3: Right click on the row header and select Insert Rows.
The row will inserted as seen in the below image,