How to Combine 2007 Excel Files

Save

Microsoft Excel 2007 shared workbook files can be combined into one file using Excel's Compare and Merge Workbooks utility. This utility is built in to Excel and does not require any additional installations to be used. The workbooks will be merged in the order they are selected. For example, if you select Doc1, Doc2 and Doc3 in that order, then the merged file will first show the contents of Doc1, then Doc2 and then Doc3.

  • Click the "Office" button in the top left corner of the Excel 2007 window, and then click "Word Options."

  • Select "All Commands" from the "Choose commands from" drop-down box.

  • Select "Compare and Merge Workbooks" from the displayed list of commands.

  • Click "Add" and then "OK."

  • Open the Excel document into which you want to merge other Excel documents, and then click "Compare and Merge Workbooks" on the Quick Access Toolbar.

  • In the "Select Files to Merge into Current Workbook" dialog box that opens, choose the Excel document that you want to combine into the currently open Excel document, and then click "OK." To select multiple files, press and hold the "Ctrl" key on your keyboard and then click on the Excel files one by one.

References

  • "Microsoft Office Word 2007 Step by Step;" Joyce Cox and Joan Preppernau; 2007
Promoted By Zergnet

Comments

Resources

You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!