You can also use this method in your actual worksheet. Last, press the button “Esc” to cancel the copy selection.Therefore, the five blank rows will be inserted into the worksheet. In the new menu, choose the option “Insert Copied Cells”.Now click the row header of the target row in the list.Besides, you can also use the shortcut keys “Ctrl + C” on the keyboard to copy those blank rows. After that, choose the option “Copy” in the sub menu.And then right click the target area in those rows.You may change the row numbers according to your need. Select any 5 blank rows in the worksheet.In this method, you will use the copy and paste method in Excel. You can also use this method in inserting multiple columns. You can see that this method can also insert multiple rows into the worksheet quickly. 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.