How to insert / add new row in MS Excel 2013?
To insert/add new row in the workbook you can use any of the options given below.
Option 1: Click on the row header above which you need a new row and select Insert.
For example, if you want to insert a row above the row 4, select row header 4.
Below image shows the new row which is inserted above the selected row.
Step 1: Right click on the row header and select Insert.
Step 2: Insert dialog box opens, enable the Entire row radio button and click OK.
A new row is inserted above the selected row header.