When creating all sorts of new tables, reports and price lists, it is impossible to foresee the number of required rows and columns. Usage Excel programs is largely the creation and adjustment of tables, which requires the insertion and removal of various elements.
First, let's look at ways to insert sheet rows and columns when creating tables.
Please note that this lesson specifies hotkeys for adding or deleting 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 hot key combination: SHIFT + SPACEBAR. Hotkeys for selecting a column: CTRL+SPACE.
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 the price list item numbers, you can use one of two methods:
Now you can fill in the new column with price item numbers.
Insert multiple columns between columns at once
Our price list still lacks 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 on the sheet."
Or highlight the two column headings 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 were previously selected. The order of the insertion columns also depends on the order in which they are selected. For example, through one, etc.
How to insert string in Excel between rows?
Now let's add a heading and a new product item "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, for persuasiveness, enter A1;A4 in the name field and press Enter). You already know how to select nonadjacent ranges from the previous lessons.
Now again use the tool "Home" - "Insert" - "Insert Rows on Sheet". The figure shows how to insert a blank line in Excel between rows.
It is easy to guess the second way. You need to select the headings of lines 1 and 3. Right-click on one of the selected lines 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 above selected lines.
Removing rows and columns
In the process of working with Excel, you have to delete rows and columns of a sheet at least as often as you insert them. So it's worth practicing.
For an illustrative example, let's remove the numbering of product positions and the column of units of measure from our price list at the same time.
Select a non-contiguous range of cells A1;D1 and select "Home" - "Delete" - "Delete columns from sheet". The context menu can also be removed if you select the headings A1 and D1, and not the cells.
Deleting lines occurs in a similar way, only you need to select the corresponding tool menu. And in context menu- without changes. You just need to select them accordingly by line numbers.
To delete a row or column in Excel, use the hotkeys CTRL + "minus" 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. It's just that the last ones replace the previous ones... This fact should be taken into account when filling the sheet with data by more than 50% -80%.
For users who do not want or simply do not need to master all the intricacies of the Excel spreadsheet processor, Microsoft developers have provided the ability to create tables in Word. Earlier we already wrote about solving a number of problems from this area, and today we will touch on another, simple, but no less relevant topic - adding columns.
The need to expand, or rather, supplement, created in Microsoft Word tables can arise for various reasons, but in the context of our topic today, they are not particularly important. Much more important is how exactly this can be done and which of the available options is the simplest and most convenient to implement. In order to understand this, it is necessary to consider each of them in detail, which we will do next.
Method 1: Table Tools Tabs
After creating a table in a document, as well as after adding / inserting any other elements other than text, separate tools for working with content appear in Word of this type. Tab group "Working with tables", which becomes available after its creation, is what will help in solving our today's task.
Note: Tab group "Working with tables" is displayed in the document only when the table itself is active, that is, the cursor pointer is generally on it (full selection) or inside any of the cells.
Method 2: Mini-panel and context menu
There is a slightly easier way to add a new column to a table in a Microsoft Word document, and besides, it is always available, no matter what tab of the program you are in.
- Right-click (RMB) in the cell next to which you want to add a column. This action will bring up a context menu in which you should hover the cursor over the item "Insert".
- Next, from the list of available options, select the appropriate one, depending on where you want to add a column:
- "Insert Left";
- "Insert Right".
- An empty column will appear in the table on the side that you yourself specified, but this is not the only quick way to add it.
Right-clicking in a table cell brings up not only a context menu, but also a mini-panel with a set of basic controls.
It has a button "Insert", and clicking LMB on it brings up a similar menu with available options for adding columns and rows. 
Which of the two, almost identical options for the same method to use, is up to you.
Method 3: Insert elements
If you move the cursor over the point in the table where its outer border (frame) intersects with the column border, you will see what is called "Insert element"- a small plus sign, dressed in a circle. To add an empty column, just click on it with LMB
Note: On devices with touch screen, provided there is no mouse and/or touchpad, this opportunity will not work.
Conclusion
All the ways we have considered to add a column to a table in Microsoft Word are extremely simple and intuitive in their implementation, so just choose the one that suits you best.
When compiling tables, it often becomes necessary to add information to an already completed table, for example, the name of a new employee. To do this, you must first insert an empty row into the table, and then enter the necessary data.
In order to insert an empty line between the filled rows of the table, you first need to select the line before which the empty line should be inserted. To do this, left-click on the line number before which you want to insert an empty line. The line will be highlighted.
After that, on the Home tab, select the Cells group, and in it the Paste command.
The column is inserted into the table in the same way. First select the column before which we want to make changes. To do this, click on its title, and then on the Insert button. An empty column will immediately appear in front of the selected column.
The Paste command can also be selected from the pop-up menu that appears as a result of right-clicking in a selected row or column.
Add and remove row, column in Excel
can be anywhere in the table. You can insert several rows, columns at once in the right place in the table.There are several ways.
TOhow to add a column to an excel spreadsheet.
First way.
To insert a column in Excel, you need to place the cursor on the row of column names, on the column next to which you want to insert a column. The new column will appear to the left of the selected column.
For example. There is a column "A" with the numbers 1, there is a column "B" with the numbers 2. You need to insert a column between them.
Hover the mouse over the address of the column in front of which we need to insert a new column. A black arrow will appear on the address letter of that column. 
Click on the right mouse button. In the dialog box that appears, select "insert" in the second section, click left button mice.
A new column has appeared to the left of column "B" (with the numbers 2).
Note!
The column addresses have changed.Now the new column has become "B", and the former column "B" (with the numbers 2) has become - "C".
The second way.
Insert column in Excel is to call the context menu on any cell of the column, to the left of which we will insert a new column. Also select "paste" in the second section of the window that appears. And here we already choose - "column" -> "OK".Read about the context menu .
Let's take a look at this menu. Here you can choose what we want to insert: a column, a row, cells that will stand to the right or below the selected cell.
If you first select not one, but several cells, columns, rows (as many as we need to insert), then the same number will be inserted.
The third way.
You can set Excel to insert columns automatically. See the article "How to add a column in Excel automatically".
How to add a row in Excel.
We need to select the cell above which we will insert newline, and call the context menu. Or hover over the address of the row and then just like inserting a column.
You can also select multiple lines at once this way and then paste the same number.
For example. We need to insert three lines between lines 3 and 4. New lines will appear above the selected line. So we mark lines 4,5,6.
We press "insert". It turned out like this.
The new lines took the place of the old lines, and the old ones moved down, changing their address.
Add blank rows in Excel after one, two rows, etc.
For example, we need to insert empty lines between rows throughout the table in a filled table, etc. How to do this, see the article "".
How to create a table in Excel, see the article "How to create a table in Excel".
How to delete a row, column in Excel.
To delete rows, columns, you need to select them and, in the context menu in the second section, select the "Delete" function.Or select rows, columns on the rows of their addresses. Right-click on the address number of the selected line and select the "Delete" function.
How to select rows, columns, see the article "How to select cells, tables, etc. in Excel." .
In a table, you can not delete a column, rows, but hide them. For example, a column with formulas, etc. How to do this, see the article "How to hide columns in Excel".
When creating a questionnaire, price list, other documents, you need to make a drop-down list in the cell, which appears when you hover the mouse over the cell.How to do this, read the article "
Working with a table in text Microsoft editor Word, you can't always guess the required number of rows and columns. Therefore, if you miscalculated, you do not have to delete it and retype it again. It is enough to add one or more rows or columns in the right places.
You can read the article on how to add rows to a Word table by clicking on the link. If you want to add a column to the table, then it is not at all difficult to do this, and I will talk about this in this article.
The first way is to go to the Layout tab.
Place the cursor in any cell of that column, to the right or left of which you want to add a new one. Next, go to the tab "Working with tables"- "Layout" and in the group "Rows and Columns" press the button or "Insert Left", or "Insert Right".
An empty column will be placed in the plate on the selected side.
To add several new columns, select the appropriate number in the finished table. For example, we will add three pieces, which means that I also select three. Then on the "Layout" tab, choose which side to install them on.
In the example, I added three empty columns.
The second way is to call the context menu.
Place the cursor in the cell from the column on both sides of which you want to add a new one, and right-click on it. Select "Insert" from the context menu, and then select the insert from the desired side.
The new column will be added.
To add not one, but several columns, select the appropriate number in the finished plate. Then click on the selection with the right mouse button and select from the menu "Insert", then specify which side.
In the example, two columns were selected, respectively, the same number was added.
In newer versions of the Word editor, 2013 and 2016, making another column can be much easier than the methods described above. Hover your mouse over the vertical border where you want to add a new column. A plus sign will appear at the top of the table, click on it and the column will appear in the specified location.
In these ways, you can supplement the finished table in Word and insert the required number of empty columns into it.
Rate article:
Loading...