If you have more than two windows open at the time you click the View Side by Side command button (Alt+WB), Excel opens the Compare Side by Side dialog box where you click the name of the window that you want to compare with the one that’s active at the time you choose the command. In this dialog box, under Compare Side by Side with, click the workbook that contains the worksheet that you want to compare with your active worksheet, and then click OK.

Select Vertical to view the windows side by side, as you did when you snapped them to the sides of the screen. 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 …

In Excel, you can compare multiple sheets across different workbooks with the Arrange All function. Creating a split screen to view 2 spreadsheets side by side. Now, you can easily scroll down your mouse to view your excel sheets side by side at the same time. By default, the View Side by Side option displays the two spreadsheet windows horizontally. On the View tab, in the Window group, click View Side by Side.

Once your windows are side by side and you've clicked the Synchronous Scrolling button, you will see how both sheets scroll simultaneously.

Click the View tab In the Windows group, click on the ‘View Side by Side’ option.

Arranging multiple sheets.

Below are the steps to align two files side by side and compare them: Open the files that you want to compare.

The Arrange Windows dialog box displays. If you want to arrange multiple sheets in Excel, you have to open these …

In each file, select the sheet that you want to compare. How to view sheets side by side in Excel – Excelchat Using New Window feature to view sheets side by side.

To change the view, click Arrange All in the Window section of the View tab. Open all workbooks you want to compare, and activate one of them, and clickView>Arrange All.

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

You can open two sheets side by side using the New Window feature. On the View tab, in the Window group, click View Side by Side. 1. Views:162931 Open both of the workbooks that contain the worksheets that you want to compare.

If you have more than two workbooks open, Excel displays the Compare Side by Side dialog box. When you click on View Side by Side, it tends to reset any split screen setup you already had, so you may need to drag your window to the right again to see them side by side.