Insert New Row in MS Excel 2013

How to insert / add new row in MS Excel 2013?

Explanation

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.

Option 2:
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.

Related Topics