Insert / Add Row in Spreadsheet

How to insert or add row in OpenOffice Spreadsheet?

Explanation

There are three options to insert a single row,
Option 1:
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.

Option 2:
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,
"

Related Topics