How to View Excel Sheets in Separate Windows (4 Methods)

Get FREE Advanced Excel Exercises with Solutions!

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.

STEPS:

  • First of all, go to the View tab and select New Window. Or, press Alt + W + N from the keyboard.

View Two Excel Sheets of Same Workbook in Separate Windows

  • Secondly, select View Side by Side from the View tab.

View Two Excel Sheets of Same Workbook in Separate Windows

  • After that, select Arrange All. The Arrange Windows message box will pop up.

View Two Excel Sheets of Same Workbook in Separate Windows

  • Now, select Tiled and click OK to proceed. Here, you can choose different options instead of ‘Tiled’ according to your purpose.

View Two Excel Sheets of Same Workbook in Separate Windows

  • Finally, you will see results like the picture below.

View Two Excel Sheets of Same Workbook in Separate Windows

  • 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.

View Two Excel Sheets of Same Workbook in Separate Windows

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.

STEPS:

  • In the first place, open both of the workbooks.
  • Secondly, go to the View tab and select View Side by Side.

Display Two Excel Sheets of Different Workbooks Side by Side in Separate Windows

  • Thirdly, select Arrange All from the View tab.

Display Two Excel Sheets of Different Workbooks Side by Side in Separate Windows

  • In the following step, select Tiled and click OK to proceed.

Display Two Excel Sheets of Different Workbooks Side by Side in Separate Windows

  • In the end, you will see two Excel sheets of different workbooks in separate windows.

Display Two Excel Sheets of Different Workbooks Side by Side 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.

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.

Open Multiple Excel Sheets to View in Separate Windows

  • 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.

STEPS:

  • 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.


Conclusion

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.


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Mursalin Ibne Salehin
Mursalin Ibne Salehin

Hi there! This is Mursalin. I am currently working as a Team Leader at ExcelDemy. I am always motivated to gather knowledge from different sources and find solutions to problems in easier ways. I manage and help the writers to develop quality content in Excel and VBA-related topics.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo