Excel 2016 Level 2 18 L E S S O N 7 M A N A G I N G W O R K B O O K S What Why

Excel 2016 level 2 18 l e s s o n 7 m a n a g i n g w

This preview shows page 18 - 23 out of 39 pages.

Excel 2016 Level 2 18
Image of page 18
L E S S O N 7 – M A N A G I N G W O R K B O O K S What Why 6. Click the Time Sheet Tab on the right pane worksheet. Switches to the Time Sheet worksheet. 7. Press the Alt + F4 keystroke combination. Closes the workbook without saving changes to the Lesson 7:1 file. 8. Click the File tab and choose Close from the File Options pane. Click Don’t Save when asked to save your changes. Closes the Lesson 7 file without saving changes. © 2015 PCM Courseware, LLC 19
Image of page 19
L E S S O N 7 – M A N A G I N G W O R K B O O K S 7.6 Comparing Two Workbooks Side by Side In this lesson, you will learn how to view two open workbooks side by side. hen working with multiple workbooks, you may at times need to copy or move data from one document to another or perhaps compare the content of two documents. In addition to the New Window command, Microsoft Excel includes the View Side by Side feature, located on the Window group of the View Ribbon, allowing you to display two open workbooks alongside one another. You need to have at least two different documents opened in order to use this feature. W The Synchronous Scrolling button on the Window group allows you to synchronize scrolling – that is to say, when you move the scrollbar upwards or downwards, both worksheets move in that direction. If you modify the window position of one of the worksheets, you can restore the Side by Side view by clicking the Restore Window Position button . To return to normal view, click the View Side by Side button. Excel 2016 Level 2 20
Image of page 20
L E S S O N 7 – M A N A G I N G W O R K B O O K S To Display Two Documents Side By Side 1. Open the workbooks you wish to view. 2. Click the View tab on the Ribbon. 3. If you have only two open workbooks, click the View Side by Side button on the Window group. 4. If you have more than two open documents, click the View Side by Side button on the Window group and then select the workbook you wish to display along side of the active workbook from the list. Click OK . 5. Click the View Side by Side button when you are finished comparing the two documents. Let’s Try It! What Why 1. Press the Ctrl + O keystroke combination. Displays the Open dialog box, bypassing the File Options pane. 2. Click Browse in the center pane and then navigate to the Lesson Files on your desktop. Displays the Open dialog box. 3. Select the Lesson6 workbook from the Lesson Files folder and then click Open . Opens the workbook named Lesson6. 4. Press the Ctrl + O keystroke combination and then click Lesson 7 under the Today workbooks area in the right pane. Opens the workbook named Lesson7. 5. Click the View tab on the Ribbon. Switches to View commands and options. © 2015 PCM Courseware, LLC 21
Image of page 21
L E S S O N 7 – M A N A G I N G W O R K B O O K S What Why 6. Click the View Side by Side button on the Window group Displays Lesson6 and Lesson7 along side one other.
Image of page 22
Image of page 23

You've reached the end of your free preview.

Want to read all 39 pages?

  • Fall '19

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture