Microsoft Office Tutorials and References
In Depth Information
Arranging multiple workbook windows
Arranging multiple workbook windows
As you work with Excel, you will probably need to have more than one workbook open at a
time. For example, you could open a workbook that contains customer contact information
and copy it into another workbook to be used as the source data for a mass mailing you
create in Word. When you have multiple workbooks open simultaneously, you can switch
between them by clicking the View tab and then, in the Window group, clicking the Switch
Windows button and clicking the name of the workbook you want to view.
You can arrange your workbooks on the desktop so that most of the active workbook is
shown but the others are easily accessible. To do so, click the View tab and then, in the
Window group, click the Arrange All button. Then, in the Arrange Windows dialog box, click
Cascade.
Many Excel workbooks contain formulas on one worksheet that derive their value from data
on another worksheet, which means you need to change between two worksheets every
time you want to test how modifying your data changes the formula’s result. However, an
easier way to approach this is to display two copies of the same workbook simultaneously,
Search JabSto ::




Custom Search