How to view multiple sheets in one workbook?

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.

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. :)

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.

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

Add sheet and rename sheets