New window utility in MS Office

Sometimes our task requires constantly moving between two ends of the same Excel sheet or between two separate sheets of the workbook. It is time consuming and downright irritating. However, MS Excel has already provided us with amazing feature called New Window to deal with this.

So how this utility helps us? Clicking on new window will open the same workbook in a different window. This will allow us to refer to the sheets in our workbook from a separate window and excuse us from navigating the same sheet. This new window is actually just another view of the current file. It’s not a different version of the current file. So, any changes made in the current window will be reflected in the new window as well and vice-versa. You don’t need to save changes made in the new window separately! And MS Excel doesn't ask you to save separately also.

Let's try to understand this using an example. We are working on an excel file in which data is given on two different sheets, as shown below

So we have file named 'eg' in which we have data sets on two different sheets. I need to use the data from sheet 2 in sheet 1 and to make the whole work simple, I will make use of New Window feature. 

When I click on VIEW > NEW WINDOW, something like this happens

A new window opens up. The original file is renamed 'eg1' while the new file in the new window is named 'eg2'. So, the workbook name is followed by a number, making it easier to access them. 

So have you noticed? You can now bypass a series of CTRL + Page Up or Page Down keystrokes by using this tool! All you need to press is ALT + Tab or CTRL + Tab to shuffle between the two windows!

We can easily perform functions like data comparison or movement of data through the new window.

You can create multiple new windows of a file, however, we recommend current window and one new window to avoid confusion.

For best results, you can use this tool with the View Side by Side (or Arrange all (Horizontally or vertically) as shown below