Arrange multiple Windows of the same Workbook!

How to view different worksheets of the same workbook side by side?

It’s quite normal to have two workbooks opened; and more than common to view the two workbooks side by side:

Image

This could be done fairly easy:

1) On the RIbbon, Go to View –> Arrange All –> Select how you want to arrange –> OK

Image(Pls try the four different ways to see the differences)

How about to view same/different worksheet(s) of the SAME workbook together?

It requires just one more step in advance.

1) Create a new window for the workbook: Go to View –> New Window

Image

2) Note the name on the top of the window.  Now it is “12 month profit and loss.xlsx:2 – Microsoft Excel”

Image

3) Also look at the bottom, you should see two windows of the same workbook.

Image

4) Repeat the step in the 1st part: Go to View –> Arrange All –> Select the way you want –> Check “Windows of Active Workbook” –> OK

Image

5) There you go.  The screenshot below shows two windows of the same worksheet of the same workbook.  You may select different worksheet if required.

Image

Tips:  You may click the “View Side by Side” to activate “Synchronous Scrolling

Image

ImageImage

Advertisements
This entry was posted in Excel Basic, Excel Tips and tagged , . Bookmark the permalink.

Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s