How to create an additional column in excel. How to add a row in Excel

Youtube

With tables. When creating complex, large tables, it is very difficult to determine in advance the exact number of rows and columns. Therefore, it may be necessary to add them after the table has been generated. Many users, having made a mistake, spend great amount time, creating everything anew, simply because they do not know how to properly utilize the built-in Excel tools or do not even know about their existence. In this article, we will figure out how to insert a row or column in Excel between existing rows or columns. Let's get started! Go!

In most cases, users edit a table after it has been created.

If you need to add a column between two others, open the “Home” tab and in the “Cells” block on the toolbar, click on the “Insert” button. In the menu that opens, click on the “Insert columns into sheet” item. Next, right-click on the first column heading. From the list that appears, select "Insert". Ready!

If you need to add not one column, but two at once, then this is done in a similar way, only you will need to select not one heading, but two.

To add a row between two existing ones, you need to select an area of non-adjacent cells. Then everything is done as in the previous case. Go to the “Home” tab and click the “Insert” button, in the list that opens, select “Insert rows into sheet”.

Exists alternative way, which consists of highlighting with the mouse the headings of the necessary rows indicating the range. After that, use the above mentioned paste function.

Please note that new lines will be added above the ones you marked. Keep this rule in mind when working with the table. Instead of special buttons on the toolbar Microsoft Excel you can exploit combinations Ctrl keys, Shift, +, not forgetting to first select the required area. This will help to avoid unnecessary “clicks” and will speed up the work somewhat.

To delete unnecessary rows or columns, select a range of non-adjacent cells, and then on the Home tab, click the Delete button and select the option that corresponds to either deleting columns or deleting rows. You can also use the key combination Ctrl+-, after noting desired area to save time.

When creating various kinds of new tables, reports and price lists, it is impossible to predict in advance the number of required rows and columns. Using Excel is largely a matter of creating and customizing tables, which involves inserting and deleting various items.

First, let's look at ways to insert worksheet rows and columns when creating tables.

Please note that this lesson specifies hotkeys for adding or removing rows and columns. They must be used after selecting an entire row or column. To select the line on which the cursor is located, press the hotkey combination: SHIFT+SPACEBAR. Hotkeys for selecting a column: CTRL+SPACEBAR.

How to insert a column between columns in Excel?

Let's say we have a price list that lacks item numbering:

To insert a column between columns to fill in price list item numbers, you can use one of two methods:

Now you can fill in new column price list item numbers.

Inserting multiple columns between columns at once

Our price list is still missing two columns: quantity and units of measurement (pcs. kg. l. pack.). To add two columns at the same time, select the range of two cells C1:D1. Next, use the same tool on the main tab “Insert” - “Insert columns into sheet”.

Or highlight the two column headers C and D, click right click mouse and select the “Paste” option.

Note. Columns are always added to the left side. The number of new columns appears as many as they were previously allocated. The order of insertion columns also depends on the order of their selection. For example, after one, etc.

How to insert a row between rows in Excel?

Now let’s add a title and a new product position “New Product” to the price list. To do this, insert two new lines at the same time.

Select a non-adjacent range of two cells A1;A4 (note that instead of the “:” symbol, the “;” symbol is indicated - this means select 2 non-adjacent ranges; to be convincing, enter A1;A4 in the name field and press Enter). You already know how to select non-adjacent ranges from previous lessons.

Now use the Home - Insert - Insert Rows in Sheet tool again. The figure shows how to insert a blank line in Excel between rows.

It's easy to guess the second method. You need to select the headers of rows 1 and 3. Right-click on one of the selected rows and select the “Insert” option.

To add a row or column in Excel, use the hotkeys CTRL+SHIFT+plus after selecting them.

Note. New lines are always added on top of the selected lines.

Removing Rows and Columns

When working with Excel, you have to delete rows and columns of a sheet no less often than insert them. So it's worth practicing.

For clear example Let's remove the numbering of product items and the column of units of measurement from our price list - at the same time.

Select the non-adjacent range of cells A1;D1 and select “Home” - “Delete” - “Remove columns from sheet”. The context menu can also be deleted if you select the headings A1 and D1, and not the cells.

Removing rows occurs in a similar way, only you need to select the appropriate tool menu. And in the context menu - no changes. You just need to highlight them accordingly by line numbers.

To delete a row or column in Excel, use the CTRL + “minus” hotkeys after selecting them.

Note. Inserting new columns and rows is actually a replacement. After all, the number of rows 1,048,576 and columns 16,384 does not change. Just the latest ones replacing the previous ones... This fact should be taken into account when filling the sheet with data more than 50%-80%.

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

"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 lines to different areas finished table Excel. 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.

Hello to all blog readers. In this article, we continue to familiarize ourselves with the basics of working in spreadsheets and look at some techniques for processing rows and columns. Beginner users may have difficulty working with these objects due to lack of experience. Today we will close the gaps in your knowledge and increase your level of literacy in spreadsheets.

Basic definitions

Strings in a spreadsheet, they are a set of horizontal cells, sequentially following each other. A columns– respectively, a series of vertical cells. The lines are numbered with Arabic numerals in ascending order, starting with top line. Columns are designated by letters ( letters).

If you see numbers instead of letters in the column names, then your spreadsheet processor is configured to display cell addresses in the alternative R1C1 format. You can switch to the usual mode with the command File – Options – Formulas – Working with Formulas – Link Style

Changing the cell naming style

Changing Row Heights and Column Widths

Changing row heights and column widths has already been described in a previous article. Therefore, I will repeat here, but in a slightly different way. You can change the parameters of rows and columns not only on a single object, but also on several at once. First, you need to select the stock (click on it serial number) or a group of lines (press and hold left button mouse on the line number and move the cursor up or down within the numbering area).

Selecting rows

Selecting columns is similar, but we use the column naming area.

Selecting columns in Excel

You can quickly change row heights or column widths by dragging the border between selected rows or columns. Actions are available in the row numbering or column naming area.

How to add a line between lines

Right-click on the line number before which you want to insert a new line. From the context menu, select Paste. A blank line appears above the highlighted line.

Adding new blank lines

If you select two lines, two empty lines will be inserted. I think the logic is clear.

How to add a column

Similar to the example with rows, select the column before which you want to insert a new one. Right-click on the selected column name and select the command Insert.

Inserting a new column in Excel

You can also insert multiple columns.

How to swap rows or columns

To exchange column (row) values, do the following actions:

Insert an empty column (row). The action is described above.
Cut the contents of the moved column (row).
- Select column (row)
- Execute the Cut command (Scissors button on the Home tab)
Insert the cut into an empty column (row).
- Click on the first cell of a column (row)
- Execute the Paste command (Insert button on the Home tab)
Remove extra empty column (row).
- The steps for deleting a column (row) are similar to inserting, only select the Delete from command context menu.

How to group rows

If the sheet spreadsheet contains a large amount of data that cannot be viewed within the visible area of the screen, then you can group rows. For example, the price of a store digital technology contains a large number of products. For structuring, products are divided into groups that can be expanded or collapsed.

Example of multi-level row grouping

To the left of the line numbers there are plus/minus buttons for expanding and collapsing a group of rows. The number of grouping levels is displayed at the top (highlighted with a red rectangle). Number buttons allow you to expand and hide rows of the corresponding level.

To create a group:

Select the required number of lines.
On the tab Data In chapter Structure select team Group.

If you need to specify the name of the group, then you need to leave a line above the selected area.

To create a multi-level grouping, expand the previously created group and inside it do the same steps to obtain the second level.

Dear reader! You have watched the article to the end.
Have you received an answer to your question? Write a few words in the comments.
If you haven't found the answer, indicate what you were looking for.

At times it would seem simple steps V Excel program are not fulfilled at all in a clear way. So, many users experience some difficulties when they need to add a new row to their table. Of course, it is worth noting that although this action can be performed in a few mouse clicks, it sometimes carries with it completely different consequences than were planned. Moreover, each goal has its own method.

How to insert a row in Excel

In total, you can consider three ways to insert new rows in the Excel spreadsheet editor. They all depend on the goals pursued by the user. Thus, 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 separately, which is what we will do now.

Method 1: Insert Between Lines

First of all, let's figure out how to add to Excel rows between the lines, since this is the action that users perform most often. And it is done quite simply:

Place the cursor in the cell above which you need to add a new line.
Click the right mouse button.
In the context menu that appears, select the “Insert...” option. Sometimes it happens that there will be two “Insert” lines in the menu; be sure to select the second one.
A new window will appear in which you need to indicate 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 hotkeys instead of the context menu. The fact is that the “Insert” window is called up by pressing the Ctrl + “+” keys. However, note that you need to press the plus key on the number pad, which is located on the right side of the keyboard. After pressing the hot keys, the same window will appear, in which you need to select the “Line” item and press the OK button.

Method 2: Insert at the end of the table

We've figured out how to add rows between rows in Excel, but when we try to do these steps to create new line at the end of the table the user will fail. The row will be added, but it will not carry over the formatting of the table and will be separated from it. In this case, you will have to resort to some tricks, which we will discuss now:

Holding down the left mouse button, select the lowest row of the table you created.
Hover your cursor over the square located in the lower right corner of the selection.
Hold down the left mouse button and drag this selection down the required number of lines.
Release the mouse button.

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

Select new cells from which you want to remove information.
Right-click on the selection.
From the context menu, select "Clear Contents".

Immediately after this, all text from the cells will be removed, but the formatting will remain.

Method 3: Create a Smart Table

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

Select the entire table.
Go to the main tab.
In the panel, select Format as Table.
Select the one you like from the list of templates.

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

Conclusion

So we figured out how to add rows between rows and at the end of the table in Excel. I especially want to highlight last method, which involves creating a “smart” table. Ultimately, it will make working with the data in it several times easier, which is undoubtedly an advantage.