How to add a new column to an excel table. Adding Previously Copied Rows

All tips

19.02.2017

Sometimes a user, while creating a table, forgets to enter some data. When he begins to realize that he missed valuable information or forgot to add it, he tries to fit everything he needs into the finished table. However, in this way you can make a number of mistakes, as a result of which other data may disappear, or simply nothing will change.

This usually happens to beginners who know little about the functionality of the Excel spreadsheet and how to add rows of information to a finished table. You can try several effective methods, which will help you add or remove rows in the sheet and in the table itself.

How to add a row to an Excel table

Excel spreadsheet processor is the most convenient and functional program to create tables. It has special functions that help change the appearance of ready-made documents. Both professionals and beginners can easily add lines in absolutely every corner of the object.

Method 1: Flipping the table

Method 2: adding with the “Tab” key, selecting with the “Enter” key

This method is suitable if you need to lengthen rows or add columns and cells. Here you only need a keyboard.

Method 3: adding with the "Enter" key

This method is very similar to the previous one. The key will be used again here "Enter".

Method 4: Stretch the Table

You can insert a line using the mouse without using the keyboard.

Method 5: Paste via context menu

There is another way to insert an additional row.

Method 6: Adding Multiple Lines

right click

context menu

"Insert"

"Table rows above"

How to insert lines in different places

Many people are tormented by this very question, since they often have to add rows in different parts of the table. However, this task will become long and tedious if you insert one line at a time all the time. What if there are a hundred of them, and they are located in different parts of the table? Then this method will help us.

Now you know how to add rows to various parts of the finished Excel table. As you can see, there are many ways, especially since each of them is working and simple. Perhaps the information provided will be useful to you in the future and you will use it.

Excel - Basic office program, which is used by almost all office workers. Excel is used for various accounting and financial calculations, calculations of future value, analysis of statistical data, etc. Based on this, it is extremely important to be able to freely work with this program and perform any actions. This article will show you about such a simple action in an Excel table as adding a row.

So, to add a row in an Excel table, you need to do the following:

Open Excel

In order to open Excel, you need to enter the word “Excel” into the search. The result will appear, clicking on which you will open new document. This is done if you want to create new table. In the same case, if you need to open an existing one, enter the file name into the search. A list of existing tables will also appear if you simply enter the name of the program into the search.

Inserting a Row

Each line has its own serial number. These numbers start from one and go down to an indefinite number. In order to insert a row in Excel tables, you need to right-click on the row number above which you want to insert an additional field.

Consider this example: lines from 1 to 10 contain numbers from ten to one hundred. For example, we want to insert multiples of five between these numbers as follows: 5, 15, 25, etc. Click on the line with serial number 1 right-click and select the “Insert” tab from the drop-down menu.

Row inserted. We enter the value we need there and continue these actions until we achieve the result we need.

As you may have already noticed, the process of adding a row to an Excel table is very simple and straightforward. Learn to use this program correctly, because knowledge of it is required in almost every job.

First, select a cell, or several cells, in the place where we plan to insert new elements. You need to select the same number of cells that will be inserted. For example, if you need to insert three cells, select three elements. Now right-click on them and select the command to add cells - “Insert”. A window will appear, using which you can insert cells. At the same time, we select the direction of shifting the elements - there are two options, to the right side, down.

Or, you can go to the “Home” tab and use the “Insert” item to bring up the same dialog box.

In it, select the necessary parameters by moving the elements to the right or down. Then, confirming the operation - “OK”. As we see in the figure below, after performing the steps described above, new cells were successfully added.

The addition of additional cells to the table is completed, while the old ones, while maintaining their values, are shifted down, giving way to space.

You can also insert cells without opening the dialog box (default). To do this, click “Insert” in the control panel without selecting options.

In this case, also, but by default, the old cells are shifted downwards. When inserting ranges of cells, it is advisable not to use the Insert tool without the options box to avoid confusion in a complex table.

To install cells filled with formulas with placed data, you need to copy or cut them. Then click on the place for their insertion with the right mouse button. In the control panel, select the command to paste copied or cut elements.

To repeat cell insertions, click the selected places and press CTRL+Y.

The task was successfully completed. So in a simple way, adding new cells to tables in Excel. It must be remembered that when adding cells, the process of moving the value of some cells to others occurs. This must be taken into account if the sheet is more than half filled. In this case, an unpleasant situation may arise in which the cells will run out and the ongoing process will cause the deletion of current data.

Nowadays, many people use Excel. But not everyone knows how to add a row to its table. On the one hand, this may seem very simple action. But on the other hand, there are a lot of pitfalls here. Let's look at different cases.

The first step is to create some kind of table in Excel. To do this, you must perform the following steps.

Select any area. Left-click on an arbitrary point on the sheet and, without releasing your finger, drag to the right and down.

Click on the “Home” tab on the “Borders” icon. Then select “All Borders” from the drop-down menu.

As a result, you will have a small table. You can also use ready-made templates.

Fill it with any values.

For clarity of further steps in filling out, digital values were used.

Using the context menu

To insert a row, you must do the following.

Move the cursor anywhere. Right click your mouse.

In the menu that appears, click on the “Insert...” item.

As a result of this, you will see several options:
- cells, shifted to the right;
- with a downward shift;
- string;
- column.

Select the third item and then click on the “OK” button.

Thanks to this, you will have a new empty horizontal row.

But what if you need a new row that does not span the entire width of the table? In this case, things are a little more complicated.

Select one cell and call up exactly the same menu again. Only this time we select the second item. We complete the action with the “OK” button.

This will result in an empty area. That is, the new cell is inserted between the rows and columns exactly in the place where you were before calling the context menu.

In order to insert not one empty element, but two or more, it is necessary to allocate an equal number.

We repeat the steps described above to add cells. This will add a row with 3 elements. This is exactly how much was allocated at the beginning before calling the menu.

Please note that when inserting exactly "rows" it does not matter which column you are in. A new horizontal row will be added across the entire width of the sheet. Other tables may also be affected!

Working with Multiple Tables

Let's imagine that we have 2 of them.

As mentioned above, the result of inserting a whole row will disrupt the appearance of the neighboring table, since a gap will appear there too.

The result will be as follows.

Everything on the right remained exactly the same.

Via the toolbar

You can get the same effect through another menu. To do this you need to do the following.

Go to the “Home” tab and click on the “Insert” button.

As a result, the following menu will appear.

To insert lines, click on the appropriate item.

Immediately after this, another row will be added, and everything else will be at the bottom.

This method is more convenient because you have to perform fewer actions.

Now try clicking on the “Insert Cells” option.

You will see exactly the same options that appeared through the context menu.

Call this menu You can use the hotkeys Ctrl + Shift += . Excel tells us this if we work through the top panel.

Add without menu

If you select several cells and hover over a corner, you will notice that it appearance is changing.

If you left-click and drag down, you will see the following.

The last row will be duplicated. If it were empty, then you would get several more of the same horizontal elements.

It is also worth paying attention to the fact that if you write any text after the table, this element will automatically copy the design of the parent cell.

Conclusion

Thanks to simple steps, which were described above, you will be able to insert new lines:

at first;
in the middle;
at the end of the table (at the very bottom).

These methods are suitable for Excel 2007 and higher.

Video instruction

Below is a video showing additional comments. It will be of interest to those who have any questions.

Paste or Ctrl+V is perhaps the most effective tool available to us. But how good are you at it? Did you know that there are at least 14 in various ways inserting data into Excel sheets? Surprised? Then read this post to become a paste master.

This post consists of 2 parts:

— Basic insertion techniques

— Insertion using data processing

1. Paste values

If you just want to paste values from cells, press the Z, M, and Z keys in sequence while holding down Alt key, and finally press the enter key. This is necessary when you need to get rid of formatting and work only with data.

Beginning with Excel 2010, the Paste Values feature appears in a pop-up menu when you right-click

2. Paste formats

14. What is your favorite insertion method?

There are many more hidden ways insertions such as inserting XML data, images, objects, files, etc. But I'm wondering what interesting insertion techniques you use. Write what is your favorite insertion method?