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:


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


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


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


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


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.


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




About MF

An Excel nerd who just transition into a role related to data analytics at current company......😊 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: Logo

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