Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

How to view multiple sheets in one workbook?

user-image
Question ajoutée par Utilisateur supprimé
Date de publication: 2015/07/21
Michael Lagunday
par 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
par 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
par 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
par Sibish Cherotayil , Subject Matter Expert , Sutherland Global Services

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

Hershey Alvarez
par Hershey Alvarez , MLHUILLIER TAGUIG BRANCH , MLHUILLIER TAGUIG BRANCH

Add sheet and rename sheets

More Questions Like This