Three ways to add rows in Excel

Sometimes, it would seem, simple actions in Excel are not performed in a completely understandable way. So, many users have some difficulties when adding a new row to their table. Of course, it is worth noting that although this action can be performed in a few clicks of the mouse, it sometimes carries with it the completely different consequences that were planned. Moreover, for each goal there is a method.

How to insert a row in Excel

In total, you can consider three ways to insert new rows in the Excel spreadsheet editor. All of them depend on the goals pursued by the user. So, the procedure for adding a row between rows is quite different from what you need to do to add a row at the end of the table. That is why it is necessary to consider each method, how to add rows separately in Excel , which is what we are going to do now.

Method 1: Insert Between Rows

First of all, we’ll figure out how to add rows between rows in Excel, since this is the most often performed action by users. And it runs quite simply:

1. Place the cursor in the cell above which you need to add a new row.
2. Click the right mouse button.
3. In the context menu that appears, select the "Insert ..." option. Sometimes it happens that there are two “Insert” lines in the menu, be sure to choose the second one in a row.
4. A new window will appear in which you need to specify what exactly you want to insert. Accordingly, set the switch to the "String" position and click OK.

If you want to speed up the process of inserting a line between lines, you can resort to using hot keys instead of the context menu. The fact is that the "Paste" window is invoked by pressing the keys Ctrl + "+". However, note that you need to press the plus key on the digital panel, which is located on the right side of the keyboard. After pressing the hot keys, the same window will appear, in which it is necessary to select the item "String" and click OK.

Method 2: insert at the end of the table

We figured out how to add rows in Excel between rows, however, when you try to perform these steps to create a new row at the end of the table, the user will fail. The row will be added, however, it will not transfer the formatting of the table and will be isolated from it. In this case, you will have to resort to some tricks, which will now be discussed:

1. Holding the left mouse button, select the bottom row of the table you created.
2. Hover over the box in the lower right corner of the selection.
3. Hold down the left mouse button and drag this selection down to the desired number of lines.
4. Release the mouse button.

After this, the table will expand, but the user may not be satisfied with this state of affairs, since along with formatting, the text from the last line was transferred to new lines. To fix this, follow these steps:

1. Select the new cells from which you want to remove information.
2. Right click on the selection.
3. From the context menu, select the "Clear Content" item.

Immediately after this, all text from the cells will be deleted, and formatting will remain.

Method 3: create a smart table

To make working with a table even easier, you need to group the rows in Excel. In other words, create a smart table. This will allow you not to resort to all sorts of tricks, which were described in the previous method. This is done simply:

1. Select the entire table.
2. Go to the main tab.
3. In the panel, select the "Format as table" item.
4. From the list of templates, select the one you like.

Immediately after that, a smart table will be created. Now you can add new lines in it both at the end and in the middle. This was the third way to add rows in Excel, which is the last one.

Conclusion

So we figured out how to add rows between rows and at the end of a table in Excel. I especially want to highlight the latter method, which implies the creation of a “smart” table. Ultimately, it will facilitate the work with the data in it several times, which, of course, is an advantage.