How to add multiple rows at once in excel

When working with tables in Microsoft Office Excel, it is often necessary to insert a line or several lines in the middle of a table array between adjacent elements in order to add the information necessary for the user to them, thereby supplementing the plate. How to add lines to Excel will be discussed in this article.

How to add one row at a time in Excel

To increase the number of rows in an already created table, for example, in its middle, you need to do a few simple algorithm steps:

  1. Use the left mouse button to select the cell next to which you want to add a new range of elements.
How to add multiple rows at once in excel
Selecting a cell to add a line later
  1. Right-click on the highlighted area.
  2. In the context type window, click on the “Insert …” option.
How to add multiple rows at once in excel
The context menu of the selected element. We find the “Insert …” button and click on it with the left mouse button
  1. A small “Add cells” menu will open, in which you need to specify the desired option. In this situation, the user must put the toggle switch in the “String” field, and then click “OK”.
How to add multiple rows at once in excel
Necessary actions in the “Add cells” window
  1. Check result. The new line should be added to the allocated space in the original table. Moreover, which stood out at the first stage, will be under an empty line.
How to add multiple rows at once in excel
One row that was added to the table array after all manipulations were completed

Pay attention! Similarly, you can add a large number of rows, each time calling the context menu and choosing the appropriate option from the list of values ​​presented.

How to add multiple rows to an excel spreadsheet at once

Microsoft Office Excel has a built-in special option with which you can cope with the task in the shortest possible time. It is recommended to follow the instructions, which practically do not differ from the previous paragraph:

  1. In the original data array, you need to select as many rows as you need to add. Those. you can select already filled cells, it does not affect anything.
How to add multiple rows at once in excel
Selecting the required number of rows in the source data table
  1. In a similar way, click on the selected area with the right mouse button and in the context type window, click on the “Paste…” option.
  2. In the next menu, select the “String” option and click “OK” to confirm the action.
  3. Make sure that the required number of rows has been added to the table array. In this case, the previously selected cells will not be deleted, they will be under the added empty lines.
How to add multiple rows at once in excel
Four rows that were added to the table after the selection of four data rows

How to remove inserted blank lines in Excel

If the user mistakenly placed unnecessary elements in the table, he can quickly delete them. There are two main methods for accomplishing the task. They will be discussed further.

Important! You can delete any element in the MS Excel spreadsheet. For example, a column, a line or a separate cell.

Method 1. Uninstalling added items via the context menu

This method is simple to implement and requires the user to follow the following algorithm of actions:

  1. Select the range of added lines with the left mouse button.
  2. Right-click anywhere in the selected area.
  3. In the context type window, click on the word “Delete …”.
How to add multiple rows at once in excel
Selecting the item “Delete …” in the context menu of the added empty cells
  1. Check result. Empty lines should be uninstalled, and the table array will return to its previous form. Similarly, you can remove unnecessary columns in the table.

Method 2: Undo the previous action

This method is relevant if the user deletes rows immediately after adding them to the table array, otherwise the previous actions will also be deleted, and they will subsequently have to be performed again. Microsoft Office Excel has a special button that allows you to quickly undo the previous step. To find and activate this function, you need to proceed as follows:

  1. Deselect all elements of the worksheet by clicking LMB on any free area.
  2. In the upper left corner of the screen next to the “File” button, find the icon in the form of an arrow to the left and click on it with LMB. After that, the last action performed will be deleted, if it was adding lines, then they will disappear.
How to add multiple rows at once in excel
Location of the “Cancel” button in Microsoft Office Excel
  1. Click the undo button again if necessary to delete several previous actions.

Additional Information! You can undo the previous step in MS Excel using the Ctrl + Z hotkey combination by pressing them simultaneously from the computer keyboard. However, before that, you need to switch to the English layout.

How to add multiple columns at once in Excel

To implement this procedure, you will need to perform almost the same steps as in the case of adding lines. The algorithm for solving the problem can be divided into the following stages:

  1. In the table array, using the left mouse button, select the number of columns with filled data that you want to add.
How to add multiple rows at once in excel
Selecting the required number of columns in the table for the subsequent addition of empty columns
  1. Right-click anywhere in the selected area.
  2. In the context menu that appears, click LMB on the line “Insert …”.
  3. In the window for adding cells that opens, select the “Column” option with the toggle switch, and click “OK”.
How to add multiple rows at once in excel
Selecting the “Column” position in the opened menu for adding cells
  1. Check result. Empty columns should be added before the selected area in the table array.
How to add multiple rows at once in excel
The final result of adding four empty columns to an Excel spreadsheet

Pay attention! In the context window, you need to click on the “Insert …” button. There is also the usual “Paste” line, which adds the previously copied characters from the clipboard to the selected cell.

Conclusion

Thus, in Excel it is very easy to add several rows or columns to an already prepared table. To do this, you need to use one of the methods discussed above.

Leave a Reply