With the help of a convenient software application Microsoft Office Word with a clear intuitive interface, even a novice PC user will be able to convert any document. The program allows you to format data, highlight it with color, paint the space around a certain block, and also create various kinds of tables. The multifunctional toolkit of the product has enormous capabilities that are necessary in order to beautifully and competently manage tabular data stored in several formats. Any table space can be created, merged, or split using a text editor. While all of the above steps are simple, some people may find it difficult to carry out such actions in practice. In this article, we will look at ways to help make a table break or join several separate fields with cells.

Most often, the need to combine graphs divided into several parts is required as a result of subsequent data formatting when the document boundaries increase or decrease. This kind of manipulation leads to a complete inconsistency of the previously created page breaks with their endings. The user has to re-combine everything in order to break it later in accordance with the new rules.

This article will talk about simple "horizontal" division and merging relative to strings. Software features Word applications are such that, in practice, vertical splitting or generic joining with respect to columns simply will not work.

Working in the Word 2003 version

It is quite simple to combine tables in Word that have the same number of columns; for this, the user needs to place the cursor directly on the break line, which is located under the first block of tabular data, then gradually press the Delete button. After a few moments, the data previously located separately will be combined into one table.

Do not despair if table blocks contain columns that have different widths, for this you just need to align them in width. There is no need to perform this time-consuming operation manually, the user will be helped by a very useful command "Align Columns Width", which is located in context menu, called after the table is selected and the selection is clicked. There are times when the automatic alignment does not correspond to the wishes or needs of the consumer, so first you need to combine the two parts of the broken table, and then manually adjust the width in a way that is more appropriate for specific data.

Working in Word 2007 and higher

Despite the many innovations that have appeared in more modern versions software product, you can also quickly and easily join a table in Word 2007 by using the Delete button and the cursor positioned in the break.

One-stop solution

As practice shows, in text editor There is one most convenient method that allows you to quickly combine tables that, by their nature, have the same number of columns with different widths. So, in order to use a unique way and equalize the width of the columns in several subsequently merged tables, you will have to first select the second table, simultaneously hold down the Ctrl + X buttons. This action contributes to placing the clipped data on the clipboard. Then you need to put the cursor on the line that is located after the first table. Pressing the Ctrl + V buttons at the same time will allow you to back-paste the copied data into the area where on this moment the cursor is located.

At first glance, this method may seem more complicated than the first, however, after the work is done, the user himself will be able to appreciate the convenience and simplicity of this method, which does not require either time or labor. It is worth noting that this kind of manipulation can be used even when tables have very large formatting.

... and click Insert

Separation of information blocks

The need to split a table in Word arises no less often than it joins. One of the most simple and quick ways, helping to carry out the plan, is the use of a special combination of buttons. Setting the cursor on a line will help to make a break, which after division will take place in the new tablespace.

After the user has determined the place of the break, it is necessary to simultaneously press the Ctrl + Shift + Enter buttons. In just one click, the one-piece canvas will be divided into 2 parts.

A more complex method that allows you to make a break in the Word, most likely, will also not cause any difficulties. To execute it, you need to put the cursor on the same line, which will become the first in the new table, then find in the main menu the subcategory that is responsible for working with tables. Among other commands, you should find the "Layout" tab, by clicking on the "Divide" command, the whole table space will be divided into two independent parts.

Conclusion

In fact, the Microsoft Word text editor is ready to help those who use it in everything. It is enough to know just some specific key combinations or certain commands and the user can very quickly join the table or make the required break in it.

You can concatenate rows from one table to another by simply pasting data into the first blank cell below the target table. The table will grow in size and new rows will be added to it. If the rows in both tables are the same, you can combine the columns from one table with the other by inserting them in the first blank cell to the right of the table. In this case, the table will grow to accommodate the new columns.

Concatenating rows is fairly straightforward, but joining columns can be very tricky if the rows in one table do not match the rows in another table. Some alignment problems can be avoided by using the VLOOKUP function.

Concatenate two tables using VLOOKUP

In the example below, you will see two tables with the names that were previously used for the new names: "blue" and "orange". In the blue table, each row is a line element for an order. Thus, order number 20050 has two elements, order number 20051 has one product, order number 20052 has three elements, and so on. We want to combine the Sales ID and Region columns with the Blue table based on matching values ​​in the order code columns in the orange table.

The order ID values ​​are duplicated in the Blue table, but the Order ID values ​​in the orange table are unique. If you were to simply copy and paste the data from the orange table, then the sales ID and area values ​​for the second position of row 20050 would be off by one row, which would change the values ​​in the new columns in the Blue table.

Below is the data for the blue table, which can be copied to a blank sheet. After you paste it into the sheet, press CTRL + T to convert it to a table, and then rename the Excel table in blue.

Below is the data for the orange table. Copy it onto the same sheet. After you paste it into the sheet, press CTRL + T to convert it to a table, and then rename the table to orange.

You must ensure that the Sales ID and Region values ​​for each order will align correctly with each of the items in each unique order item. To do this, paste the Sales ID table headers and region into the cells to the right of the blue table and use VLOOKUP formulas to get the correct values ​​from the Sales ID and Region columns in the Orange table.

Here's how to do it:

Learn more about tables and VLOOKUP functions

additional information

You can always ask the Excel Tech Community a question, ask for help in the Answers community, and also suggest new function or improvement on the website

Working in Excel is undoubtedly an invaluable experience that will be useful to every user. Of course, I am not saying that every user should be fluent in this tool, but the more knowledge you have, the better. In my previous articles, I have repeatedly talked about the capabilities of Excel, about the subtleties, graphs and tables. In addition, more than once the speech came about the application of certain functions in practice.

This time I propose to discuss the question of how to combine tables in excel. To be more precise, this is called "consolidation" of tables, and this feature is in great demand. Well, let's not beat around the bush, let's figure out what it is and why it is needed at all.

If the tables are the same

As you can imagine, table consolidation makes things a lot easier. It allows you to create pivot table by combining the data of all the others into one. Let's first consider the first option, when the tables, in general, are of the same type, the difference is only in numbers. In this case, it is very simple to bring them together, you just need to sum the values ​​in the cells. How this is done, I already told you: it is used, which will sum up all the values ​​that are the same by quarters and names (in a particular case). That's all, the principle of action is very simple.

If the tables are different

It is not uncommon for the source codes to differ in many criteria or are executed on different files. As you can imagine, using the previous option is unlikely to work, it is a painfully time-consuming process. And since the summation of cells disappears, you need to look for other options.

Fortunately, there is such an option! Let's imagine that we have three different tables that need to be merged.

They can be completely different, but there is one condition: in such tables, the headings of the lines and columns must match. The fact is that the first row and the left column of each table is the criterion by which search system Excel will find matches and sum them up among themselves.

How do I complete a consolidation? Everything is very simple:

I hope this small educational program will help you quickly and efficiently combine several tables in Excel into one.

Video to help

You have already worn out with tables and would like to know how you can split a table in a Word into two parts and put it back together again?

Splitting and joining a table may be required in several cases - you need to remove part of the records from the table, you need to transfer part of the table to a new sheet, or vice versa, take a table from a scanned document, insert it into new document and join two tables into one - glue them.

The problem is that many users do not consciously perceive the Word table as real, drawn on a sheet of paper and believe that it cannot be torn. In fact, the table can not only be broken, but also put together, and now we will try to learn this trick.

For training, we need an example of a table in document word and keyboard.

(Picture 1)

How to split a table into a Word

For example, we need to split a table so that rows 2 and 3 are split and become a separate table.

1. We put the cursor in the first cell of the row of our "second" table. For example, I put the cursor in front of the number 2, this cell will become the first, after breaking the table by two.

2. While holding Ctrl key press Enter.

3. We get two tables, breaking one. We have only one cell in the first table in the word document, in the second - two, as it was intended.

(Figure 2)

It is possible that the table jumps too much to the second sheet.

In this case, just put the cursor after the table and press Enter to move the cursor to the line below, and then Del to delete all non-printable characters after the cursor and raise the table.

How to connect a table to a Word

The process of joining tables is to remove all characters that separate the tables.

(Figure 3)

In the figure, it is easy to see that between the tables there is an end-of-line character - Pi.

It is not necessary to see it, just place the cursor after the first table and press the DEL key on your keyboard. You will see how the lower table at the beginning will rise, and then join, glue to the upper table.

In fact, the process of joining tables can be complicated by the fact that two tables can have cells of different widths, which will not be the same when joining.

In this case, you will need to position the cursor in a cell with the wrong width and stretch it in the desired direction.

I hope this tutorial will help you master the skill of splitting and joining tables in five minutes, and your work will become easier.

Have a nice day and see you in the next lessons.

When working with tables in text Word editor it is not uncommon to find it necessary to split or join tables. Separation is usually not a problem because Word has a separate button for this procedure. But, joining tables often fails experienced users to a dead end. They cannot find a button that would be responsible for this function and, accordingly, do not know what to do. In this article, we will look at two ways at once, how to combine tables in Word 2003, 2007, 2010, 2013 or 2016.

Method # 1. Removing all characters between tables.

The easiest way to combine tables in Word is to simply delete all characters between the two tables. When doing this, you need to remove both visible characters and invisible (non-printable) ones. To do this, place the cursor between the tables and delete all characters between them (including spaces) using the Backspace key.

After all characters between the two tables have been deleted, you need to press the Delete key. This will remove any invisible line break between tables and they will automatically be merged.

If you do not quite understand why you need to press the Delete key, then on the "Home" tab there is a button " Show all signs". If you click it, then all characters will be displayed in the document.

This will allow you to understand what is preventing the merging of tables and what we are deleting by pressing the Delete key.

Method number 2. Cut out the second table and paste it below the first.

The second way to combine tables in Word involves using the functions "Cut" and "Paste" (Ctrl-X and Ctrl-V). The advantage this method is that you don't need to delete text between tables. After joining the tables, the text will simply move down.

In order to use this method, you need to select the lower part of the table with the mouse and cut it using the Ctrl-X key combination or using the "Cut" function in the context menu.

After that, you need to place the cursor immediately after the first table (before the text that was between the tables).

And paste the cut table using the Ctrl-V key combination.

As a result, you will concatenate the tables. At the same time, the text that was previously between the tables was not deleted, but simply shifted down the combined table.

Addition. How to split tables.

It also needs to be mentioned about splitting tables. In order to split the previously joined tables, you need to place the cursor in the table on the line with which the second table should begin. Then you need to go to the " Working with tables - Layout"And click on the button" Split tables". You can also split tables using the Ctrl-Shift-Enter key combination.

If you have Word 2003, then to split the concatenated tables, you need to open the "Table" menu at the top of the window and select the "Split Table" item there.