When you create an Excel workbook for each subject of your business, you will sometimes need to look at data from more than one workbook to make your decisions. In cases like this, you can switch between them by choosing the workbook’s name from the list displayed when you click the Switch Windows button on the View tab, or you can choose one of several arrangements so that you can work with your workbooks effectively.
Open three workbooks; then, on the View tab in the Window group, click Arrange All. In the Arrange All dialog box, select the Cascade option and click OK. The workbooks will be displayed with a slight overlap, with the full contents of the first workbook displayed and the title bars of the other two workbooks visible behind the first workbook.
3.129.218.45