In this article you will find how to compare two spreadsheets by viewing them simultaneously in Excel 2016, 2013 and 2010
You'd like to compare two Excel worksheets and need to open and see them side by side. However simple it may seem, each time they appear in the same window. That's frustrating! So we will show you how to view two Excel files (.xls or .xlsx) side by side in this step by step tip. You may want to choose one of the following options:
Let's begin with the first option. As a start, open the two workbooks you want to compare. You can see now that there are two task-bar buttons for Excel. Whichever workbook you click, it appears in the same window. Find the Window section on the View tab and then click View Side by Side.
By default, this will show your spreadsheets in separate panes horizontally. You may want to change the orientation. So you can click the Arrange All button and choose Vertical to have your tables side by side in the left-hand and the right-hand columns.
There is one more option that you may like. Click Synchronous Scrolling to scroll down both spreadsheets at the same time and compare the differences.
Excel will remember your last side by side view selection to open future files.
Sometimes it is necessary to view several sheets of one and the same Excel workbook. So all you need is to open this workbook and click the New Window button on the View tab. Then pick the View side by side option. You can click New Window again to view as many spreadsheets of the same workbook as you need.
You may want to see several Excel workbooks in different windows. It can be really handy if you've got two monitors. So first open one file. Then run one more copy of Excel from the Start menu. As a result you will be able to open another workbook in this new window and modify it to your liking.
We hope this snap tip will help everyone compare data from two workbooks or worksheets.
33 responses to "View Excel workbooks side by side"
Or you can open up another sesssion of Excel 2010....
Exactly!
However the sheets won't scroll together.
REALLY SUPERB
Thank you, Dinakar!
Hi,
How to view two sheets vertically in the same file ?
thanks
Hello, Srikanth,
I'm really sorry, looks like this is not possible.
How do you undo this feature? I don't want to view the worksheets side by side anymore, but Excel remembers this setup every time I restart the program.
Thank you!
Hi LA,
Click on the View tab, and click View Side by Side under the Window group.
reply to srikanth
Open new window then change that to the second sheet you want to view and then view side by side
Reply to LA
Before closing excel, close the second worksheet and just have one open. click save and excel should remember your standard layout.
Thanks Maria, this solved my problem in excel 2003, very much appreciated :)
Once I have selected Arrange All to see my 2 excel files side by side, is there an easy way to reverse which one is on the left & right? Is there a quick keystroke to reverse these? Right now, I am manually reversing their position, but I have to make sure they are fit correctly to the space.
Regrettably, there is no such shortcut, at least I don't know any. The active book, one in which you clicked the Arrange All button, is always on the left (or at the top if you align horizontally).
To reverse the order, switch to the other workbook (one that is on the right or at the bottom), and click the Arrange All button there. Alternatively, switch to the right-hand file, press Alt+W, hold Alt and press A, then press V, release Alt and press Enter.
Does NOT show how to open two separate spreedsheets when you have to Monitors.
Hello,
Sorry, we cannot help you with this.
Very nice
Thanks!
I have a number of files open but only want to view 2 of them side by side and I don't want to close the others as I am still working with them. If I choose arrange all, ALL the files show up side by side. Can I not just change the default orientation of "view side by side" from horizontal to vertical?
Hello,
Please try to open new window then change that to the second sheet you want to view and then view side by side.
In a workbook with several sheets, I have only the 1st column for customers the same , but the remaining are different data for same customer , so when I jump between sheets, the columns should jump to same in all sheets. the number of columns is more than 500 & so the requirement.
Hello, James,
I'm really sorry we cannot help you with this task.
This is actually an incredibly frustrating automatic feature. Excel recently made it impossible to open two excel spreadsheets in separate windows and now force you to use this view feature. not only does it add numerous extra steps to just simple view to sheets side by side but it also makes things incredibly frustrating if you are working with over 10 spreadsheets at a time.
personally this is one of the worst parts of excel I am yet to experience
How to filter those sheets at a time
Fine
nice plz send me others same like issue solutions.
Hi, I am currently using excel 2013. The features View Side by Side, Synchronous Scrolling, and Reset Window Position are all greyed out. Any idea how to remedy this where those features can be utilized?
Hello, Cristy,
To make these options active, you need to open more than 1 Excel file.
If you want to view several sheets of one and the same Excel workbook, please open this workbook and click the New Window button on the View tab. Then pick the View side by side option.
Hope this will work for you.
Thanks a lot for making my worker faster ^&^
I have worked on one of the document and save, how do I remove the duplicated work sheet if i don't want it?
When I try to type numbers from one open "side by side" work book from the other, the work book I am typing the numbers FROM disappears. I need to work on both open work books at the same time. I don't just need to view them side by side, I need to work on them while both workbooks are open.
Nice. Very Useful notifications
Thanks for the help! very useful info.