As
you work with Excel, you will probably need to have more than one
workbook open at a time. 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.
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.
To
display two copies of the same workbook, open the workbook and then, on
the View tab, in the Window group, click New Window to opens a second
copy of the workbook. To display the workbooks side by side, on the View
tab, click Arrange All. Then, in the Arrange Windows dialog box, click
Vertical and then click OK. When you change the data in either copy of the workbook, Excel updates the other copy.
If the original workbook’s name is Student Details, Excel displays the name Student Details:1 on the original workbook’s title bar and Student Details:2 on the second workbook’s title bar.
TROUBLESHOOTING:
