Excel: merge worksheets
Related Videos: How to Merge Data from Two Excel Worksheets (May 2024).
You have created several spreadsheets in Excel and want to combine them into one? In this practical tip we will show you how this works.
Merge Excel spreadsheets: Using the consolidation function
Latest videos
Image 1: First select the cell in Excel in which the worksheets are to be merged. Then click on "Consolidate".
Image 2: A window opens, select the marked character to the right of "Reference:".
Image 3: Switch to the other worksheet and select one of the cells to be merged. Then confirm the selection by clicking on the button marked in the image or by pressing the Enter key.
Image 4: Under "Add" you can place your selection on the existing references.
Image 5: Repeat the last steps until you have added all references. Under "Function:" you select what should happen with the references, in our case we would like to add the numbers. Then click "OK".
Photo 6: You will finally receive the result.
Excel tables have different positions at the beginning. You must first use the consolidation function to merge your tables:
- First click on the cell in Excel in which the data should be merged (see image 1, step 1).
- Then select the "Data" tab and click on the "Consolidate" button within the "Data tools" group to open the dialog window (see Figure 1, Step 2).
- Click the button to the right of the "Reference:" field (see image 2).
- Now switch to another sheet and select one of the cells that you want to consolidate. Then acknowledge this by clicking on the button on the right in the window (see Figure 3).
- Add your selection to your existing references with "Add".
- Repeat the last three steps until you have selected all references.
- In the "Function" field you can select various mathematical functions for consolidation. In our case, we just want to add the selected cells together. Click on "OK" (see figure 5).
- Now the desired cells were put together (see picture 6).
Merge whole tables
Latest videos
Image 1: Select the cell where the merged table should start. Now choose "Consolidate".
Image 2: Next, select all of the tables to be merged. Then push them into the existing references.
Figure 3: Depending on the table type, select where your table label is located in the lower left. Now click on "OK".
Image 4: Now all the values in your table have been combined.
Whole tables can also be combined using the reference function in the "Consolidate" dialog box.
- First select the cell where you want the merged table to start later. Then click on "Consolidate" under the "Data" tab (see Figure 1).
- Similar to the first chapter, select the first table to be consolidated and add your selection to the existing references with "Add" (see Figure 2).
- Repeat this until you have selected all the tables again.
- Depending on which table type it is, tick the "Top row" and / or "Left column" selection (see Figure 3).
- After clicking "OK", the table with the merged data is now displayed (see Figure 4).
There can be various reasons if your Excel program suddenly stops calculating. Read more about what these are and what you can do in another practical tip.
$config[ads_text5] not found