How to Merge Documents in Excel 2007

By Matt McGew

Microsoft Excel 2007 is a spreadsheet application that is part of the Microsoft Office 2007 productivity suite. One of the features of Excel 2007 is the ability to create shared workbooks that allow multiple users to view and make changes to spreadsheets. It is then possible to merge the data from the different workbooks back into a single document. This feature allows multiple people to easily collaborate and contribute to a single Excel document.

Things You'll Need

  • Microsoft Excel 2007

Step 1

Create an Excel document and then click on the "Review" tab in the "Changes" group. Click the option "Share Workbook." Click the "Editing" tab and check the box next to the option to "Allow changes by more than one user at the same time."

Step 2

Create a folder on your PC's desktop by right-clicking on your desktop. Save the original Excel document to this new folder by clicking "Save As" and then selecting the new folder on your desktop as the destination for the Excel document. Save the copy of the Excel document you want to merge into the original document in the same folder on your PC's desktop. Make sure the two files have different file names.

Step 3

Open the original Excel document. Click "Tools" from the Excel window's toolbar. Select "Compare and Merge Workbooks." A dialog box will open and ask you to "select the files to merge into current workbook." Select the document you would like to merge into the original Excel document. Click "Ok."

Tips & Warnings

  • If you want to merge multiple documents at the same time, hold down the Control or Shift key and click the names from the multiple files. Click "OK."