Viewing two sheets of the same workbook side by side

Viewing two sheets of the same workbook side by side

ü  Go to View tab and in the Window group, click on New Window. This will open a copy of your workbook and also activate the View Side by Side option.

ü  Now click on View Side by Side. (View Tab & Window Group)

ü  Now in a Window you have two views side by side, click the worksheets that you want to compare i.e. sheet1 in first view and sheet2 in second view.

ü  To scroll both worksheets at the same time, click Synchronous Scrolling in the Window group on the View tab.

NOTE: This option is available only when View Side by Side is turned on.

To view two sheets next to each other or in a tiled layout

For this just stay in the View Tab and click on the Arrange All button. This will give multiple display options i.e. Tiles, Horizontal, Vertical & Cascade. Please try the one of your choice.