To disable synchronous scrolling, just click this button to toggle it off. The option resides on the View tab, right below View Side by Side, and activates automatically with the latter. As its name suggests, it allows scrolling both sheets at the same time.

One more handy feature that you may like is Synchronous Scrolling. Cascade - windows overlap one another from top to bottom.Įxcel will remember your selected arrangement and use it the next time.Horizontal - windows are placed one below another.Tiled - windows are arranged as equally sized squares in the order you opened them.Or choose another option that suits you best: In the Arrange Windows dialog box, select Vertical to place the sheets next to each other. To change the default composition, click the Arrange All button on the View tab.

When using the View Side by Side feature, Excel positions two windows horizontally. How to arrange sheets side-by-side vertically 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.

In each workbook window, click the tab you want to compare.

To view two sheets in different workbooks side by side, this is what you need to do: To arrange the tabs vertically, use the Arrange All feature. The image below shows the default horizontal arrangement.

In each window, click the desired sheet tab.

On the View tab, in the Window group, click View Side by Side.

This will open another window of the same workbook.

On the View tab, in the Window group, click New Window.If the sheets you want to compare are in the same workbook, here are the steps to place them side by side: How to view two Excel sheets side by side View two sheets of the same workbook side by side.Luckily, it's as easy as it appears to be :) Just choose the technique that fits your situation: When it comes to comparing worksheets in Excel, the most obvious solution is to place tabs next to each other. In this article, you will learn how to open two or more windows side by side in Excel 365, 2021, 2019, 2016, 20.

How to close all windows in excel