by Svetlana Cheusheva, updated on
In this article, you will learn how to open two or more windows side by side in Excel 365, 2021, 2019, 2016, 2013 and 2010.
When it comes to comparing worksheets in Excel, the most obvious solution is to place tabs next to each other. Luckily, it's as easy as it appears to be :) Just choose the technique that fits your situation:
Let's begin with the most common case. If the sheets you want to compare are in the same workbook, here are the steps to place them side by side:
The image below shows the default horizontal arrangement. To arrange the tabs vertically, use the Arrange All feature.
To view two sheets in different workbooks side by side, this is what you need to do:
In case you have more than two files open, the Compare Side by Side dialog box will pop up asking you to choose the workbook to be compared with the active one.
When using the View Side by Side feature, Excel positions two windows horizontally. To change the default composition, click the Arrange All button on the View tab.
In the Arrange Windows dialog box, select Vertical to place the sheets next to each other.
Or choose another option that suits you best:
Excel will remember your selected arrangement and use it the next time.
One more handy feature that you may like is Synchronous Scrolling. As its name suggests, it allows scrolling both sheets at the same time. The option resides on the View tab, right below View Side by Side, and activates automatically with the latter. To disable synchronous scrolling, just click this button to toggle it off.
The methods described above work for 2 sheets. To view all sheets at a time, proceed in this way:
Repeat this step for each worksheet that you want to view. If the sheets are in different files, skip this step.
If the View Side by Side button is greyed out, that means you have just one Excel window open. To activate it, open another file or another window of the same workbook.
If the View side by Side button is active, but nothing happens when you click on it, click the Reset Window Position button on the View tab, in the Windows group.
If resetting the position does not help, try this workaround:
As a final note, it's worth pointing out a couple of helpful tip-offs:
These are the fastest ways to view Excel tabs side by side. I thank you for reading and look forward to seeing you on our blog next week!
Table of contents