Viewing a worksheet in multiple windows

Excel 365 2016 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, choose New Window.

Window group in Excel 2013

Then on the View tab, in the Window group, choose Arrange All and choose one of the options in the Arrange Windows dialog box to display the open windows. Excel displays a new window for the active workbook:

Arrange Windows in Excel 2013

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 colon and a number to each window.

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).

New window in Excel 2013

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.

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.

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.

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

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information you’ve provided to them or they’ve collected from your use of their services.

Learn more