View Multiple Sheets or Workbooks at the Same Time

1. Open the workbooks you want to view. To view multiple sheets in the active workbook, click New Window on the Window menu. Switch to the new window, and then click a sheet you want to view. Repeat for each sheet you want to view.

2. On the Window menu, click Arrange.

3. Under Arrange, click the option you want. To view sheets in only the active workbook, select the Windows of active workbook check box.

To restore a workbook window to full size, click Maximize at the upper-right corner of the workbook window.

Close Workbook Windows

For active workbook windows, click Close in the upper-right corner of the window. If the window is the only open window of the workbook, the workbook is closed.

For all open windows of a workbook: On the File menu, click Close.

For all open workbooks: Hold down the SHIFT key, and then click Close All on the File menu