4 Effective Methods to Insert Multiple Rows or Columns into Your Worksheet

Inserting rows or columns into a worksheet is a very easy process. But sometimes you need to insert multiple rows or columns into a worksheet. You can use the 4 methods in this article.

Due to the need of a task, you will need to insert multiple rows or columns into a worksheet. The image below shows a list of product names.An Example for Multiple Rows or Columns

And now you need to insert 5 rows after row 8. And you can follow the steps below to learn those different methods.

Method 1: Insert Manually

This is the most ordinary method in Excel.

  1. Right click the target row header in the worksheet to select the whole row.
  2. And then choose the option “Insert” in the sub menu.Insert

Thus, there will be a new row in the range.New Row

  1. Next repeat the steps and insert other rows into the worksheet.

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

Method 2: Use the F4 Key

In this method, we will use the F4 key on the keyboard.

  1. Repeat the first two steps and insert a row into the worksheet.
  2. Now, press the button “F4” on the keyboard. Thus, the action of inserting a row will take effect again. And you will see that there will be new rows below the row 9.F4
  3. Now press the button F4 again until you get the numbers that you need.

Compared with the previous method, this method is indeed quicker. And when you need to insert columns, the “F4” button also works.

Method 3: Use the Shift Key

Here comes the third method. In this method, you will need to use the “Shift” key.

  1. Click the target row header in the worksheet.
  2. And then press the button “Shift” on the keyboard and hold it.
  3. After that, move your cursor to the left bottom corner of the first cell of the row. You will see that the cursor of shape will change.
  4. And now drag the mouse downwards. You may also refer to the image below. There will be dotted line in the worksheet.Drag Downwards
  5. When the number of new rows reach to your goal, release the “Shift” key and the mouse. Thus, you have inserted those rows into the worksheet.Shift

You can see that this method can also insert multiple rows into the worksheet quickly. You can also use this method in inserting multiple columns.


Method 4: Copy Blank Rows or Columns

In this method, you will use the copy and paste method in Excel.

  1. Select any 5 blank rows in the worksheet. You may change the row numbers according to your need.
  2. And then right click the target area in those rows.
  3. After that, choose the option “Copy” in the sub menu. Thus, you have copied those rows. Besides, you can also use the shortcut keys “Ctrl + C” on the keyboard to copy those blank rows.Copy
  4. Now click the row header of the target row in the list.
  5. Next right click your mouse.
  6. In the new menu, choose the option “Insert Copied Cells”.Insert Copied Rows

Therefore, the five blank rows will be inserted into the worksheet.

  1. Last, press the button “Esc” to cancel the copy selection.Copied Rows

You can also use this method in your actual worksheet. And of course, you can also copy and insert multiple blank columns into your worksheet.

Compare the Four Methods

If you don’t know which method you can use, you may refer to the table below. We have analyzed the advantages and disadvantages of the four methods.

Comparison Insert Manually Use the F4 Key Use the Shift Key Copy Blank Rows or Columns
Advantage This method is easy to manipulate and every Excel users know how to use it. The F4 key can repeat the last action that you make, which can save you a lot of time. This method can quick insert multiple rows or columns without repeating steps. Through this method, you can quickly insert the copied rows or columns into the worksheet.
Disadvantage This method will be time-consuming if you need to insert many rows or columns. If you need to input many rows or columns into a sheet, you should press this button continuously. You will certainly be very bored and be confused about the numbers. You need to be very careful when putting your cursor to the left bottom of the selected row. And holding the “Shift” key can be tired. Sometimes there will be invisible contents in rows. Hence, if you need to input some values into the cell, you may meet with errors.

Excel Recovery Tool is a Must for Excel Users

If you use Excel frequently, you can prepare an Excel recovery tool at hand. Until now, Excel is still not such perfect software that has no flaw. We have met many users who meet with Excel corruption without any sign. The reason behind the data disaster can be complex. Hence, preparing such a recovery tool is necessary. We highly suggest that you can invest out powerful tool. This tool can repair Excel damage and deal with other difficulties that most of the other tools cannot handle.

Author Introduction:

Anna Ma is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including repair docx data corruption and outlook repair software products. For more information visit www.datanumen.com

Comments are closed.