Opening a New Workbook Window

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 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 on the Task bar and on the Switch Windows drop-down list of the ribbon's View tab.

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.