Thus, you have inserted those rows into the worksheet.

When the number of new rows reach to your goal, release the “Shift” key and the mouse.

There will be dotted line in the worksheet. You will see that the cursor of shape will change.

After that, move your cursor to the left bottom corner of the first cell of the row.

And then press the button “Shift” on the keyboard and hold it.

Click the target row header in the worksheet.

In this method, you will need to use the “Shift” key. And when you need to insert columns, the “F4” button also works.

Now press the button F4 again until you get the numbers that you need.Ĭompared with the previous method, this method is indeed quicker.

And you will see that there will be new rows below the row 9. Thus, the action of inserting a row will take effect again.

Now, press the button “F4” on the keyboard.

Repeat the first two steps and insert a row into the worksheet.

In this method, we will use the F4 key on the keyboard. To solve this problem, you can continue reading this article. But if you need to insert a lot of rows into the worksheet, you will certainly spend a lot of time. And on the other hand, if you need to insert multiple columns into a worksheet, you can also use this method.

Next repeat the steps and insert other rows into the worksheet.Thus, there will be a new row in the range. And then choose the option “Insert” in the sub menu.Right click the target row header in the worksheet to select the whole row.

This is the most ordinary method in Excel. And you can follow the steps below to learn those different methods. The image below shows a list of product names.Īnd now you need to insert 5 rows after row 8. You can use the 4 methods in this article.ĭue to the need of a task, you will need to insert multiple rows or columns into a worksheet. But sometimes you need to insert multiple rows or columns into a worksheet. Inserting rows or columns into a worksheet is a very easy process.

How to add multiple rows in excel sheet