Viewing a worksheet in multiple windows

Excel 2016 2013 2010 2007 2003
Sometimes, you may want to view two different parts of a worksheet simultaneously - perhaps to make it easier to reference a distant cell in a formula. Or you may want to examine more than one sheet in the same workbook simultaneously.

You can accomplish either of these actions by opening a new view to the workbook, using one or more 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


  1. A single workbook can have as many views (that is, separate windows) as you want. Each window is independent of the others. In other words, scrolling to a new location in one window doesn't cause scrolling in the other window(s). See more how to view and compare spreadsheets side by side.
  2. If the workbook is maximized when you create a new window, you may not even notice that Excel has created the new window; but if you look at the Excel title bar, you'll see that the workbook title now has *** - 2 appended to the name.
  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, multiple windows are useful when examining formulas.

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

If you have any questions or suggestions, please feel free to ask OfficeToolTips team.