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

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.


Download Practice Book

Download the practice book here.


4 Methods to View Excel Sheets in Separate Windows

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

Read More: How to Enable Side-by-Side View with Vertical Alignments in Excel


Similar Readings


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.

Read More: How to Open Multiple Excel Files in One Workbook (4 Easy Ways)


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.

Read More: How to Open Two Excel Files Separately (5 Easy Methods)


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.


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. Last of all, if you have any suggestions or queries, feel free to ask in the comment section below.


Related Articles

Mursalin

Mursalin

Hi there! This is Mursalin. I am an Excel and VBA content developer as well as an electrical and electronics engineer. I am always motivated to gather knowledge from different sources and find solutions to problems in easier ways. I am currently working and doing research on Microsoft Excel. Here I will be posting articles related to Microsoft Excel.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo