- 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.
- On the Window menu, click Arrange.
- 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.