If you find any post useful then, please do share with others. Thanks!

Popular Posts


Email me

Need help and that also free? I like to learn this way, in case of any question or for a small task, please feel free to email me with details and example data, if required.

Thursday, September 4, 2014

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.

No comments:

Post a Comment