1 / 8

Excel Chapter 9

Excel Chapter 9. Part 4: Comparing and merging Workbooks. Comparing Workbooks. Open the file, FasToast Ovens Travel Expenses, from the Data Files for Students Open the file, FasToast Ovens Travel Expenses Maura, from the Data Files for Students.

amelia
Download Presentation

Excel Chapter 9

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Excel Chapter 9 Part 4: Comparing and merging Workbooks

  2. Comparing Workbooks • Open the file, FasToast Ovens Travel Expenses, from the Data Files for Students • Open the file, FasToast Ovens Travel Expenses Maura, from the Data Files for Students. • Click the View tab on the Ribbon Click the View Side by Side button on the Ribbon to display the workbooks side by side. Depending on how previous Excel windows were arranged on your computer, the workbooks may appear next to each other left-to-right • Use the scroll bar in the top window to scroll the FasToast Ovens Travel Expenses Maura worksheet Microsoft Office 2007: Comprehensive Concepts and Techniques - Windows Vista Edition

  3. Comparing Workbooks • Click the View Side by Side button on the Ribbon again • Click the workbook Close Window button to close the FasToast Ovens Travel Expenses Maura workbook • If Excel displays the Microsoft Office Excel dialog box, click the No button • If necessary, click the Maximize button in the FasToast Ovens Travel Expenses window Microsoft Office 2007: Comprehensive Concepts and Techniques - Windows Vista Edition

  4. Comparing Workbooks Microsoft Office 2007: Comprehensive Concepts and Techniques - Windows Vista Edition

  5. Merging Workbooks • Click the Customize Quick Access Toolbar button arrow next to the Quick Access Toolbar and then click More Commands on the Customize Quick Access Toolbar menu • When the Excel Options dialog box appears, select All Commands in the ‘Choose commands from’ list • Scroll to the Compare and Merge Workbooks command in the list on the left and then select it • Click the Add button to add the Compare and Merge Workbooks button to the list on the right side of the dialog box • Click the OK button to add the Compare and Merge Workbooks button to the Quick Access Toolbar Microsoft Office 2007: Comprehensive Concepts and Techniques - Windows Vista Edition

  6. Merging Workbooks • Click the Compare and Merge Workbooks button on the Quick Access Toolbar to display the Select Files to Merge Into Current Workbook dialog box • Navigate to where you have saved your Student Data Files. Click FasToast Ovens Travel Expenses Stanley, hold down the SHIFT key, and then click FasToast Ovens Travel Expenses Maura to select both files • Click the OK button to merge the workbooks Microsoft Office 2007: Comprehensive Concepts and Techniques - Windows Vista Edition

  7. Merging Workbooks Microsoft Office 2007: Comprehensive Concepts and Techniques - Windows Vista Edition

  8. Turning Off Workbook Sharing and Saving the Workbook • Click the Review tab on the Ribbon and then click the Share Workbook button on the Ribbon • When Excel displays the Share Workbook dialog box, click ‘Allow changes by more than one user at the same time’ to clear the check box • Click the OK button • If Excel displays the Microsoft Office Excel dialog box, click the Yes button • Click the Save button on the Quick Access Toolbar Microsoft Office 2007: Comprehensive Concepts and Techniques - Windows Vista Edition

More Related