Creating New Windows

If you want to work on two different parts of the same workbook at the same time, there are a couple of different ways you can do so. One way is to open a second window. You do this by simply choosing New Window from the Window menu or, in Excel 2007, displaying the View tab of the ribbon and clicking New Window in the Window group. Excel opens a new window. You can then use each window to display and edit different parts of the same workbook.

Notice that each new window you create has not only the workbook name in the title bar, but also a number that indicates the actual window number. Thus, you could have Book1:1 and Book1:2. These are the same way that the window names appear at the bottom of the Window menu (or on the Switch Windows drop-down list of the ribbon's View tab in Excel 2007) and on the Task bar.

Each window created in this way just provides a different way to look at the exact same workbook. This means that any change you make in one window is automatically and immediately made in the other window as well.