Quickly switch workbooks
For a small number of workbook switches, click the Workbook window.
To switch multiple workbooks under multiple windows, you can use the Window menu. The bottom of the Window menu lists the names of the open workbooks, and to switch directly to a workbook, you can choose its name from the Window menu.
The Window menu can list up to 9 workbooks. If there are more than 9, and the Window menu contains a command called "Other windows," Select the command, a dialog box that lists all the open workbook names in alphabetical order, just click the name you want.