Weekly Tip: Excel® 2007
Merging Excel Workbooks
1. On the Quick Access toolbar, click the Customize Quick Access Toolbar button, and then click the More Commands option.
2. In the Excel Options dialog box, in the Choose commands from drop-down list, click the Commands not in the Ribbon option.
3. Locate and click the Compare and Merge Workbook command, click the Add button and then click the OK button.
4. Open the copy of the shared workbook into which you want to merge changes.
5. On the Quick Access tool bar, click the Compare and Merge Workbooks button.
6. In the Select Files to Merge Into Current Workbook dialog box, select all copies of the shared workbook containing changes to be merged.
7. Click OK.
Note: Cells that have been modified are marked with a black triangle. Place the mouse over the cell to view the change.
This Tip of the Week was brought to you by the learning professionals at ExecuTrain Houston. To learn more, sign up for one of our Microsoft Office SharePoint 2007 public classes or ask about our Private Consults or Client-Site learning events.
To get the complete Quick Reference Card for Microsoft Office, contact an adivisor for pricing and delivery.