How to view multiple Excel worksheets on one screen

To view several sheets from one workbook in Excel, open an extra window with View → New Window, then choose a layout under View → Arrange All. Select a different sheet tab in each window. These steps use desktop Excel for Windows.

Open another window for the same workbook

  1. Open the workbook and select New Window in the Window group on the View tab. Open one extra window to view two sheets. Repeat once more to view three.

Window titles may show suffixes such as :1 and :2 to help you identify each view. The windows share one workbook, so changes to a cell are reflected in any window displaying that cell.

Save a separate copy first if you want to compare edits against an untouched original. An extra window opens another view of the same data.

Arrange the windows and choose the sheets

  1. Open View → Arrange All. Choose Vertical to place windows next to one another, Horizontal to stack them, or Tiled to fit several windows. If other files are open, select Windows of active workbook to limit the arrangement to the current file.
  2. Select the raw data sheet in one window and the summary in the other. Check the active tab in each window. For example, put the April sales entries on the left and the monthly totals on the right.

With three or more windows, less of each grid is visible. Keep two windows or stack them if you need to see more columns at once.

Compare two windows with synchronous scrolling

To follow the same rows in both windows, turn on View Side by Side, then enable Synchronous Scrolling in the View tab. Scroll one window and check that the other follows. Turn synchronous scrolling off to keep the summary in place while you move through the data. If the windows start on different rows, turn synchronization off, align the starting rows, and switch it back on.

To compare sheets from two different files, open both workbooks and select View Side by Side. If Excel shows a dialog because several files are open, select the workbook you want to compare with the active window.

Microsoft’s guide to viewing worksheets at the same time

Return to one workbook window

When finished, close the extra window using its close button and maximize the remaining view. Closing the final window closes the workbook, so decide whether to save any changes.

Microsoft’s guide to closing workbook windows