Excel: spreadsheet merge

You have created in Excel, multiple sheets and want them to be lead to a table together. In this practical tip we will show you how this works.

Excel Consolidation Function

The tables in Excel have the beginning of different positions. First, you must use the consolidation feature to get your tables together:

First, click on the cell in Excel, in which the first cell of the consolidation table to appear. You are in the tab in which you want the overall table to create.
Then select the tab "data" and click inside the group "data tools" button on the "Consolidate" to open the dialog window.
In the field "function" you can select different mathematical functions for the consolidation.
With the field "reference" you can click on the different working areas, mark, that you want to merge leaves.

With the help of the reference function in the dialog window "Consolidate" the table leaves together:

First, click on the button on the right within the reference function. Then select the tab of the first worksheet and highlight the whole table.
You have to click on the right button so that the dialog window is displayed again.
Then select the "Add" button. The marking is listed in the box "available references". Repeat this process for the other sheets until all of the tables in the field "Existing references" are listed.
You provided two options, "Top row" and "Left column" with a check mark and press the "OK" button. The table with the merged data will now be displayed.

To tables in Excel to merge , you have other tools available.