How to View Excel Worksheets in Multiple Windows

Often we are faced with a situation where we need to open multiple Excel worksheets simultaneously to do comparison or reference data between worksheets. In this guide, we’ll explore an important technique that allows you to open an Excel worksheet in a separate window.

Excel is a very popular number-processing application and is widely used in various fields. Excel has features that allow you to create, edit, and analyze data in the form of worksheets.

A worksheet is a collection of cells arranged in rows and columns. You can have multiple worksheets in one workbook, and you can switch between worksheets by clicking the Tab at the bottom of the Excel window.

However, sometimes you may want to view more than one worksheet at the same time, both in the same or different workbooks. For example, you may want to compare data from two different worksheets, or you may want to copy and paste data from one worksheet to another. In such cases, you can use Excel features that allow you to view worksheets in multiple windows.

There are several ways to view an Excel worksheet in multiple windows, depending on your needs and preferences. In this article, we will explain some of those ways with easy-to-follow steps.

Why You Need a Separate Window for Excel Worksheet

Before we go any further, let’s understand why you need a separate window for Excel worksheets. The main reason is efficiency and productivity. By having the ability to view multiple worksheets at the same time, you can:

1. Comparing Data: In some situations, you may need to compare data between two or more worksheets. This can happen when you want to check data consistency or look for discrepancies in numbers.
2. Refer Data: Sometimes, you need to refer data from one worksheet to another. With separate windows, you can easily view the data source and data destination at the same time.
3. Merge Data: If you are working with data spread across multiple worksheets, having separate windows allows you to quickly combine information from multiple sources.
4. Real-Time Monitoring: For projects that require real-time monitoring of data, opening worksheets in separate windows allows you to see changes over time.

View a Worksheet in a Separate Window

The first way to view an Excel worksheet in multiple windows is to open the worksheets in separate windows. In this way, you can set the size and position of the window to your liking, and you can switch between windows easily using the keys (Alt + Tab) on the keyboard.

To view the worksheets in a separate window, follow these steps:

1. Open the workbook that contains the worksheets that you want to view.
2. On the “View” tab, in the “Window” group, click “New Window”. This will create a copy of the same workbook in a new window.
3. Switch to a new window, and then click the tab for the worksheet that you want to view.
4. Repeat steps 2 and 3 for each worksheet that you want to view in a separate window.
5. Set the size and position of the window to your liking.

View worksheets side-by-side

The second way to view an Excel worksheet in multiple windows is to view the worksheets side by side. In this way, you can compare data from two worksheets directly, and you can scroll both worksheets simultaneously or separately.

To view worksheets side by side, follow these steps:

1. Open the workbook that contains the worksheets that you want to view.
2. On the “View” tab, in the “Window” group, click “View Side by Side”. It will display two workbook windows side by side automatically.
3. Switch to one of the windows, and then click the tab for the worksheet that you want to view.
4. Switch to another window, and then click the tab for the other worksheets that you want to view.
5. If you want to scroll both worksheets at the same time, make sure the “Synchronous Scrolling” option is on. If not, turn off the option.

Split a worksheet into panes

The third way to view an Excel worksheet in multiple windows is to split the worksheet into panes. In this way, you can display two different areas of the worksheet in the same window, and you can scroll in both panes separately.

To split a worksheet into panes, follow these steps:

1. Open the workbook that contains the worksheets that you want to view.
2. Select below the row where you want to split, or the column to the right where you want to split.
3. On the “View” tab, in the “Window” group, click “Split”. It will split the worksheet into four panes automatically.
4. If you want to split the worksheet into two panes only, drag the separator line to the edge of the window.
5. To resize the panel, just drag the separator line.
6. To remove a separate panel, click “Split” again.

Conclusion

In this article, we have explained several ways to view Excel worksheets in multiple windows, namely:

• View worksheets in separate windows
• View worksheets side by side
• Split a worksheet into panes

Using these features, you can increase your productivity and efficiency in working with Excel data. You can choose the way that best suits your needs and preferences, and you can customize the appearance of the window to your liking.

Hope this article was useful and informative for you. If you have any questions or suggestions, please leave a comment below. Thanks for reading.