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

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
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

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

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

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.