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:
- 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.
- 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.
- Merge Data: If you are working with data spread across multiple worksheets, having separate windows allows you to quickly combine information from multiple sources.
- 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:
- Open the workbook that contains the worksheets that you want to view.
- On the “View” tab, in the “Window” group, click “New Window”. This will create a copy of the same workbook in a new window.
- Switch to a new window, and then click the tab for the worksheet that you want to view.
- Repeat steps 2 and 3 for each worksheet that you want to view in a separate window.
- 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:
- Open the workbook that contains the worksheets that you want to view.
- On the “View” tab, in the “Window” group, click “View Side by Side”. It will display two workbook windows side by side automatically.
- Switch to one of the windows, and then click the tab for the worksheet that you want to view.
- Switch to another window, and then click the tab for the other worksheets that you want to view.
- 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.