You are viewing the article How to Merge Two Excel Worksheets at Tnhelearning.edu.vn you can quickly access the necessary information in the table of contents of the article below.
X
This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.
The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.
This article has been viewed 8,381 times.
This wikiHow teaches you how to merge data from two different sheets into one Microsoft Excel workbook.
Steps
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/6/6a/Merge-Two-Excel-Spreadsheets-Step-1.jpg/v4-728px-Merge-Two-Excel-Spreadsheets- Step-1.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/6/6a/Merge-Two-Excel-Spreadsheets-Step-1.jpg/v4-728px-Merge- Two-Excel-Spreadsheets-Step-1.jpg”,”smallWidth”:460,”smallHeight”:344,”bigWidth”:728,”bigHeight”:544,”licensing”:”<div class=”mw-parser -output”></div>”}
Double-click the workbook to open it in Excel. This workbook must contain at least 2 sheets that you want to merge.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/c4/Merge-Two-Excel-Spreadsheets-Step-2.jpg/v4-728px-Merge-Two-Excel-Spreadsheets- Step-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/c/c4/Merge-Two-Excel-Spreadsheets-Step-2.jpg/v4-728px-Merge- Two-Excel-Spreadsheets-Step-2.jpg”,”smallWidth”:460,”smallHeight”:346,”bigWidth”:728,”bigHeight”:547,”licensing”:”<div class=”mw-parser -output”></div>”}
Click + to create a new workbook. This button is located at the bottom of the workbook, to the right of the name of the last sheet.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/6/6f/Merge-Two-Excel-Spreadsheets-Step-3.jpg/v4-728px-Merge-Two-Excel-Spreadsheets- Step-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/6/6f/Merge-Two-Excel-Spreadsheets-Step-3.jpg/v4-728px-Merge- Two-Excel-Spreadsheets-Step-3.jpg”,”smallWidth”:460,”smallHeight”:343,”bigWidth”:728,”bigHeight”:543,”licensing”:”<div class=”mw-parser -output”></div>”}
Click cell A1. Just click once to select.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/0/0c/Merge-Two-Excel-Spreadsheets-Step-4.jpg/v4-728px-Merge-Two-Excel-Spreadsheets- Step-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/0/0c/Merge-Two-Excel-Spreadsheets-Step-4.jpg/v4-728px-Merge- Two-Excel-Spreadsheets-Step-4.jpg”,”smallWidth”:460,”smallHeight”:344,”bigWidth”:728,”bigHeight”:544,”licensing”:”<div class=”mw-parser -output”></div>”}
Click the Data tab at the top of the screen, located between “Formula” and “Review.”
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/6/68/Merge-Two-Excel-Spreadsheets-Step-5.jpg/v4-728px-Merge-Two-Excel-Spreadsheets- Step-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/6/68/Merge-Two-Excel-Spreadsheets-Step-5.jpg/v4-728px-Merge- Two-Excel-Spreadsheets-Step-5.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser -output”></div>”}
Click the Conspidate action in the “Data Tops” group of the top toolbar. The Conspidate panel will appear.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/9/9c/Merge-Two-Excel-Spreadsheets-Step-6.jpg/v4-728px-Merge-Two-Excel-Spreadsheets- Step-6.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/9/9c/Merge-Two-Excel-Spreadsheets-Step-6.jpg/v4-728px-Merge- Two-Excel-Spreadsheets-Step-6.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser -output”></div>”}
Select Sum from the “Function” drop-down menu. This is the first drop-down menu in the Conspidate panel.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/d/db/Merge-Two-Excel-Spreadsheets-Step-7.jpg/v4-728px-Merge-Two-Excel-Spreadsheets- Step-7.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/d/db/Merge-Two-Excel-Spreadsheets-Step-7.jpg/v4-728px-Merge- Two-Excel-Spreadsheets-Step-7.jpg”,”smallWidth”:460,”smallHeight”:343,”bigWidth”:728,”bigHeight”:543,”licensing”:”<div class=”mw-parser -output”></div>”}
Click the up arrow located to the right of the “Reference” box. The Conspidate table will shrink and be renamed to Conspidate – Reference.
- On some versions of Excel, the arrow is gray or black. On the remaining versions, you will see a small rectangle, inside there is a tiny red arrow.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/a/a6/Merge-Two-Excel-Spreadsheets-Step-8.jpg/v4-728px-Merge-Two-Excel-Spreadsheets- Step-8.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/a/a6/Merge-Two-Excel-Spreadsheets-Step-8.jpg/v4-728px-Merge- Two-Excel-Spreadsheets-Step-8.jpg”,”smallWidth”:460,”smallHeight”:344,”bigWidth”:728,”bigHeight”:545,”licensing”:”<div class=”mw-parser -output”></div>”}
Select the data in the first worksheet. Click the sheet name at the bottom of the screen, then click and drag your mouse over the data you want to merge. The data will now be surrounded by a dotted or dotted line.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/3/34/Merge-Two-Excel-Spreadsheets-Step-9.jpg/v4-728px-Merge-Two-Excel-Spreadsheets- Step-9.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/3/34/Merge-Two-Excel-Spreadsheets-Step-9.jpg/v4-728px-Merge- Two-Excel-Spreadsheets-Step-9.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser -output”></div>”}
Click the arrow in the Conspidate – Reference window. The larger Conspidate panel will reappear.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/7/7c/Merge-Two-Excel-Spreadsheets-Step-10.jpg/v4-728px-Merge-Two-Excel-Spreadsheets- Step-10.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/7/7c/Merge-Two-Excel-Spreadsheets-Step-10.jpg/v4-728px-Merge- Two-Excel-Spreadsheets-Step-10.jpg”,”smallWidth”:460,”smallHeight”:343,”bigWidth”:728,”bigHeight”:543,”licensing”:”<div class=”mw-parser -output”></div>”}
Click Add to the right of the “All references” box. We can continue to merge the selected data with data from another sheet.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/8/8d/Merge-Two-Excel-Spreadsheets-Step-11.jpg/v4-728px-Merge-Two-Excel-Spreadsheets- Step-11.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/8/8d/Merge-Two-Excel-Spreadsheets-Step-11.jpg/v4-728px-Merge- Two-Excel-Spreadsheets-Step-11.jpg”,”smallWidth”:460,”smallHeight”:344,”bigWidth”:728,”bigHeight”:545,”licensing”:”<div class=”mw-parser -output”></div>”}
Click the up arrow in the “Reference” box. As before, the Conspdate table will shrink and be titled Conspdate – Reference.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/d/df/Merge-Two-Excel-Spreadsheets-Step-12.jpg/v4-728px-Merge-Two-Excel-Spreadsheets- Step-12.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/d/df/Merge-Two-Excel-Spreadsheets-Step-12.jpg/v4-728px-Merge- Two-Excel-Spreadsheets-Step-12.jpg”,”smallWidth”:460,”smallHeight”:348,”bigWidth”:728,”bigHeight”:550,”licensing”:”<div class=”mw-parser -output”></div>”}
Select the data in the second worksheet. Click the sheet name at the bottom of the workbook, then select the data you want to merge.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/5/52/Merge-Two-Excel-Spreadsheets-Step-13.jpg/v4-728px-Merge-Two-Excel-Spreadsheets- Step-13.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/5/52/Merge-Two-Excel-Spreadsheets-Step-13.jpg/v4-728px-Merge- Two-Excel-Spreadsheets-Step-13.jpg”,”smallWidth”:460,”smallHeight”:349,”bigWidth”:728,”bigHeight”:553,”licensing”:”<div class=”mw-parser -output”></div>”}
Click the arrow in the Conspidate – Reference window.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/0/00/Merge-Two-Excel-Spreadsheets-Step-14.jpg/v4-728px-Merge-Two-Excel-Spreadsheets- Step-14.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/0/00/Merge-Two-Excel-Spreadsheets-Step-14.jpg/v4-728px-Merge- Two-Excel-Spreadsheets-Step-14.jpg”,”smallWidth”:460,”smallHeight”:347,”bigWidth”:728,”bigHeight”:549,”licensing”:”<div class=”mw-parser -output”></div>”}
Click the Add button. You will see the two selected data tables appear in the “All references” box.
- If there are other worksheets to merge, add the data in the same way as you did with the previous two sheets.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/8/89/Merge-Two-Excel-Spreadsheets-Step-15.jpg/v4-728px-Merge-Two-Excel-Spreadsheets- Step-15.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/8/89/Merge-Two-Excel-Spreadsheets-Step-15.jpg/v4-728px-Merge- Two-Excel-Spreadsheets-Step-15.jpg”,”smallWidth”:460,”smallHeight”:350,”bigWidth”:728,”bigHeight”:554,”licensing”:”<div class=”mw-parser -output”></div>”}
Check the boxes next to “Top row” and “Left cpumn” (Left column). These two cells are located in the lower left corner of the Conspidate panel.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/e/ea/Merge-Two-Excel-Spreadsheets-Step-16.jpg/v4-728px-Merge-Two-Excel-Spreadsheets- Step-16.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/e/ea/Merge-Two-Excel-Spreadsheets-Step-16.jpg/v4-728px-Merge- Two-Excel-Spreadsheets-Step-16.jpg”,”smallWidth”:460,”smallHeight”:344,”bigWidth”:728,”bigHeight”:544,”licensing”:”<div class=”mw-parser -output”></div>”}
Click OK . The selected data will be merged and displayed in the new spreadsheet.
X
This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.
The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.
This article has been viewed 8,381 times.
This wikiHow teaches you how to merge data from two different sheets into one Microsoft Excel workbook.
Thank you for reading this post How to Merge Two Excel Worksheets at Tnhelearning.edu.vn You can comment, see more related articles below and hope to help you with interesting information.
Related Search: