Viewing a worksheet in multiple windows

Excel 2016
When working with multiple tables and large amounts of data, when designing or analyzing charts or diagrams, you may need to view two or more parts of the worksheet simultaneously.

Excel allows opening a new view to the workbook, using additional windows.

To create and display a new view of the active workbook, on the View tab, in the Window group, click New Window:

New Window in Excel 365

Then, on the View tab, in the Window group, click Arrange All and choose one of the options in the Arrange Windows dialog box to display the open windows:

Arrange Windows in Excel 365

Excel displays a new window for the active workbook. In this case, each window shows a different worksheet in the workbook. Notice the text in the windows' title bars: *** - 1 and *** - 2. To help you keep track of the windows, Excel appends a number to each window:

New window in Excel 365

Notes:

  1. One workbook can have several views (that is, separate windows). Each window is independent of the others. In other words, scrolling to a new location in one window doesn't cause scrolling in other windows. See more about how to view and compare spreadsheets side by side.
  2. If the workbook is maximized when a new window is created, you may not even notice that Excel has created a new window. The Excel title bar text will change - *** - 2 added to the workbook's title or the next consecutive number if you have more views.

    Click the Arrange All button on the View tab in the Window group:

    Arrange All in Excel 365

    Then select one of the Arrange options in the Arrange Windows dialog box. If you select the Windows of active workbook check box, only the windows of the active workbook are arranged.

  3. You can close these additional windows when you no longer need them. For example, clicking the Close button on the active window's title bar closes the active window but doesn't close the other windows.
  4. Multiple windows make it easier to copy information from one worksheet to another. You can use Excel's drag-and-drop procedures to do this. In addition, several windows are convenient when viewing formulas.

See also this tip in French: Comment afficher une feuille de calcul dans plusieurs fenĂȘtres.

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.