Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How to view multiple sheets in one workbook?

user-image
Question added by Deleted user
Date Posted: 2015/07/21
Michael Lagunday
by Michael Lagunday , Accounts Assistant , Invest Group Overseas LLC

To see multiple sheets in one workbook simultaneously in Microsoft Excel2007 and2010 you need to do the following:

 

a. Go to view tab.

b. Find "view side by side" button (located at the middle top of the window)

c. modify the sizes of the windows according to your need.

 

Commonly the 'synchronous scrolling' is automatically toggle so you have to untoggle this one to scroll one sheet without scrolling the rest of the sheets.

Firas Shahadi
by Firas Shahadi , Human Resources Director , SAUDI UNION

very simple solution to tap on New window button in view tab.

then choose how you want to view them vertically or horizontally by clicking the corresponding button in View tab.

Done that is it. :)

Michael Gannon
by Michael Gannon , Data Assistant , British Film Institute (BFI)

View - New Window - Arrange All

Make sure you have only one workbook open.

Choose New Window from the View menu. Excel opens a second instance of the same workbook.

Choose Arrange All from the View menu. Excel displays the Arrange Windows dialog box.

 

Choose the method Excel should use to arrange your windows. (Tiled, Vertical, Horizontal, Cascade)

Click on OK.  Excel arranges the windows as you directed.

 

Close the second instance of the workbook when you are finished.  Everything you added in each window will be in the workbook.

Sibish Cherotayil
by Sibish Cherotayil , Subject Matter Expert , Sutherland Global Services

Split Workbook so that you can see both in one window.

Hershey Alvarez
by Hershey Alvarez , MLHUILLIER TAGUIG BRANCH , MLHUILLIER TAGUIG BRANCH

Add sheet and rename sheets

More Questions Like This