Wednesday, February 12, 2020

How to View Excel Sheets Side by Side for Data Compare & Analysis

In this tutorial, we will cover a very basic and tiny topic of MS-Excel program yet the topic is very useful for data comparing and analyze them in a systematic way.

Today, we will show you how easily you can view multiple excel sheet of the same excel file side by side at the same time. There may be some situation comes when you need to look at two sheets side by side to compare the data of two different sheets in the same excel file.

If you are not aware of this built-in function of MS-Excel then you might need to click your mouse repeatedly to view the required data from one sheet to another sheet over and over. Well, this clicking thing is a lot of time consuming and in fact, quite a boring way to compare your data and you need to remember those data in your head because you can’t see those data at the same time.

Here, we use some own generated demo data to create our excel sheets and for this tutorial the purpose we will use the data and screenshot several times.

Anyway, for solving the above problems, you can simply use a trick in MS-Excel and i.e. View Side by Side option. For that, first, open those excel sheet files (.xlsx) in MS-Excel.

Then from any sheet, click the View Tab, like the below screenshot…….

Then click on New Window option which will open a new window for your file and it also activate View Side by Side option if isn’t activated before . Follow the below screenshot,

Then, just click the View Side by Side option,

Well, that’s set and isn’t it very easy! Now, you can easily scroll down your mouse to view your excel sheets side by side at the same time.

Form this view, you can compare both sheets data more easily and accurately.

By the way, you can see an option there just below the View Side by Side option in a green marking named Synchronous Scrolling is activated which is used to scroll both sheet synchronously or at the same time both sheets can move up & down. 

If you need to stop Synchronous Scrolling then click one time on that option.

If you have doubt or you do not understand a thing of this tutorial, then ask us via comment or contact us via our CONTACT page, we will get back to you with your answers. Thank you for your support and stay with tutorialabc for better content. 

Feel free to share with your friends and family and give your valuable suggestions so that we can improve our service.

1 comment:

  1. Great post, very useful in analysing data. Microsoft Excel offers extensive functions for educational, business and various other applications. www.Office.Com/Setup