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

About MF

An Excel nerd who doesn’t work on Excel most of the time at current job...... 🤔 Recently in love with Power Query and Power BI.😍 Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.
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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.