Sometimes we need to view different Excel sheets in separate windows for various purposes. Also, we may need to compare values from different excel sheets viewing them both at the same time. Today, we will demonstrate 4 easy ways to view excel sheets in separate windows. So, without further ado, let’s start the discussion.
How to View Excel Sheets in Separate Windows: 4 Methods
To explain the methods, we will use an Excel workbook that contains multiple worksheets. We will try to view them in separate windows. The first sheet contains the dataset overview and the second sheet contains information about some employees.
And the third sheet contains some information about sellers.
1. View Two Excel Sheets of Same Workbook in Separate Windows
In this method, we will view two Excel sheets of the same workbook. To view them in separate windows, follow the steps below.
- First of all, go to the View tab and select New Window. Or, press Alt + W + N from the keyboard.
- Secondly, select View Side by Side from the View tab.
- After that, select Arrange All. The Arrange Windows message box will pop up.
- Now, select Tiled and click OK to proceed. Here, you can choose different options instead of ‘Tiled’ according to your purpose.
- Finally, you will see results like the picture below.
- In addition, select Synchronous Scrolling from the View tab to scroll both sheets at the same time. To go back to the original viewing settings, select Reset Window Position.
Read More: [Fix:] Excel View Side by Side Not Working
2. Display Two Excel Sheets of Different Workbooks Side by Side in Separate Windows
We can also display two Excel sheets of different workbooks in separate windows. You can compare datasets easily by viewing them side by side. Here, we will use a new workbook along with the previous one. Let’s pay attention to the steps below to know more.
- In the first place, open both of the workbooks.
- Secondly, go to the View tab and select View Side by Side.
- Thirdly, select Arrange All from the View tab.
- In the following step, select Tiled and click OK to proceed.
- In the end, you will see two Excel sheets of different workbooks in separate windows.
3. Open Multiple Excel Sheets to View in Separate Windows
Not only two Excel sheets, but we can also open multiple sheets to view in separate windows. In this case, we will use a single workbook that contains multiple sheets. So, without any delay, let’s jump to the steps.
- Firstly, select New Window from the View tab in the ribbon. If you want to view 3 sheets, then, select the New Window option 3 times. Or, you can press Alt + W + N to open a new window.
- After that, just resize them according to your convenience to view them properly.
Note: If you have Excel sheets from different workbooks, then, follow Method-2.
4. View Two Excel Sheets in Different Windows in Excel 2010 or Earlier Versions
The above methods may not be effective in the earlier versions of Excel. To open two Excel sheets in different windows, you need to follow a slightly different method. Follow the steps below to do so.
- At the start, open the first workbook and move it to your preferred location on the screen.
- After that, go to the Taskbar and right-click on the Excel icon. A menu will appear.
- Then, click on Excel or Microsoft Excel 2010.
- Finally, you will get another new sheet like the picture below.
Things to Remember
Sometimes, the methods may not work properly because of pre-selected settings. If you face any problem, just close the workbook and then open it again to apply the methods.
Download Practice Book
Download the practice book here.
In this article, we have demonstrated 4 easy methods to view Excel sheets in separate windows. We have used different cases to explain them. I hope these methods will help you to perform your tasks easily. Furthermore, we have also added the practice book at the beginning of the article. You can download it to learn more.
- How to Enable Side-by-Side View with Vertical Alignments in Excel
- How to Split Screen in Excel
- How to Split Excel Sheet into Multiple Files
- How to Split Excel Sheet into Multiple Worksheets
- How to Split Sheet into Multiple Sheets Based on Rows in Excel
- How to Split Excel Sheet into Multiple Sheets Based on Column Value
- How to Split a Workbook to Separate Excel Files with VBA Code
- Excel VBA: Split Sheet into Multiple Sheets Based on Rows