View multiple sheets or workbooks at the same time - Help and How-to

Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Printer-Friendly Version

View multiple sheets or workbooks at the same time

Applies to: Microsoft Office Excel 2003

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.

Show Tip

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