How to Merge Two Excel Spreadsheets

Explore this Article

Steps

Steps

Other Sections

Questions & Answers

Related Articles

This How.com.vn teaches you how to merge data from two different sheets in a Microsoft Excel workbook.

Steps

1. 
   1
   Double-click the workbook to open it in Excel. This workbook should contain at least 2 sheets that you want to merge.
2. 
   2
   Click + to create a blank sheet. It’s at the bottom of workbook, to the right of the last sheet’s name.
3. 
   3
   Click cell A1. Just click it once to select it.
4. 
   4
   Click the Data tab. It’s at the top of the screen between “Formula” and “Review.”
5. 
   5
   Click Consolidate. It’s in the top toolbar’s “Data Tools” group. The Consolidate panel will appear.
6. 
   6
   Select Sum from the “Function” drop-down menu. It’s the first drop-down menu in the Consolidate panel.
7. 
   7
   Click the upward-pointing arrow in the “Reference” box. It’s at the box’s far-right edge. This shrinks the Consolidate panel and changes its title to Consolidate – Reference.

   • On some versions of Excel, the arrow is gray and black. On others, you’ll see a tiny rectangle containing an even tinier red arrow.
8. 
   8
   Select data on the first sheet. To do this, click the sheet’s name at the bottom of the screen, then click and drag the mouse over the data you want to merge. The data is now surrounded by a dotted or dashed line.
9. 
   9
   Click the arrow in the Consolidate - Reference window. The larger Consolidate panel should re-appear.
10. 
    10
    Click Add. It’s to the right of the “All references” box. You are now ready to merge the selected data with data from another sheet.
11. 
    11
    Click the upward-pointing arrow in the “Reference” box. As before, this shrinks the Consolidate panel and changes its title to Consolidate – Reference.
12. 
    12
    Select data on the second sheet. Click the sheet’s name at the bottom of the workbook, then select the data you want to merge.
13. 
    13
    Click the arrow in the Consolidate - Reference window.
14. 
    14
    Click Add. You should now see the two selected sets of data in the “All references” box.

    • If there are other sheets to merge, add that data the same way you did for these two sheets.
15. 
    15
    Check the boxes next to “Top row” and “Left column.” They are both at the bottom-left corner of the Consolidate panel.
16. 
    16
    Click OK. The selected data is merged and appears on the new sheet.
    Advertisement

Community Q&A

Search

Add New Question

• Question

  How do I merge data in Excel spreadsheets?

  

  Tough Rules

  Community Answer

  Arrange the source data properly and run Excel Consolidate. Configure the consolidation and update settings, and follow the procedure.

  Thanks! We're glad this was helpful.
  Thank you for your feedback.
  If How.com.vn has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission.Support How.com.vn

  YesNo

  Not Helpful 36Helpful 11
• Question

  How can I create a password for my Excel spreadsheet?

  

  Community Answer

  Consult Password Protect an Excel Spreadsheet.

  Thanks! We're glad this was helpful.
  Thank you for your feedback.
  If How.com.vn has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission.Support How.com.vn

  YesNo

  Not Helpful 4Helpful 0

Ask a Question

200 characters left

Include your email address to get a message when this question is answered.

Submit

Advertisement