Tuesday, January 18, 2011

How to Use Software to Merge Two or More Excel Workbooks


1. Click the 'File' tab, and select 'Options.' In the 'Excel Options' dialog box, select 'Customize Ribbon.' In the 'Choose Commands From:' drop-down menu, select 'All Commands.'
2. Select 'Compare and Merge Workbooks' in the left hand pane, and then click 'Add.' Click 'OK' to finish the installation process.
3. Click the 'Insert' tab, and then select the 'Compare and Merge Workbooks' button. Select the workbooks you wish to merge in the dialog box. (Note that the workbooks must be in the same folder before they can be merged.) Click 'OK' when done.

Blogger news