How to add (insert) rows in Excel

In this tutorial we’ll learn the process to add / insert new rows in Excel by following these simple steps.

When we use Excel for data entry purposes, often we need to add (insert) data between the already filled rows. This could be a problem if you don’t know how to add (insert) rows in between to make room for the new data.

Step 1 – Add rows using shortcut key CTRL + SHIFT + +

– The simplest of all methods to add (insert) rows (adjacent or nonadjacent) is to select the rows and then press the shortcut key CTRL + SHIFT + +.
– This will open up the Insert dialog box giving you different options. Choose the “Entire Row” option. This will insert the same number of rows as the selected rows as shown below.

Step 2 – Add rows using Context Menu’s Insert Option

– The second method to add (insert) rows (adjacent or nonadjacent) is to select the rows and then right click to open up the context menu.
– Now click on the Insert option on this menu.
– This will open up the  Insert dialog box giving you different options. Choose the “Entire row” option. This will insert the same number of rows as the selected rows as shown below.

Step 3 – Add rows using Home Tab’s Insert Option

– The third method to add (insert) rows (adjacent or nonadjacent) is to select the rows and go to the Insert option on the Home Tab. Then click on the Insert Sheet Rows option on this menu.
– This will insert the same number of rows as the selected rows as shown below.