Viewing a worksheet in multiple windows

Excel 365 2016 2013 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 2010

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 2010

In this case, each window shows a different worksheet in the workbook. Notice the text in the windows' title bars: Book1:1 and Book1: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 2010

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.

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.