"How to View Multiple Worksheets at the Same Time in Excel 2007?"

Do you use multiple worksheets in Excel 2007? Discover the benefits of using it here.

Well, if you need to work on two worksheets at the same time, maybe for comparison purpose, Excel makes it easy to do. You just need to display two windows and arrange them to both be visible.

Then, you can quickly compare two worksheets in the same workbook by viewing them side by side. You can also use the same technique to view multiple worksheets from different workbooks. This tutorial shows you how to do that!

To view multiple worksheets at the same time

• Open the workbook that contains the worksheets that you want to view at the same time.
• On the View tab, in the Window group, click New Window icon. Excel opens a second instance of the same workbook. icon.
• On the newly opened workbook, click the View tab, in the Window group, click Arrange All icon. Excel displays the Arrange Windows dialog box.

• From the Arrange Windows dialog box displayed, choose one of the options Excel should use to arrange your windows.
• Click on OK.

In each of the windows you can display different worksheets, even though they are part of the same workbook. When you are done, simply close one of the windows. It is interesting to note that if you have a need to do so, you can view more than two worksheets from the same workbook.

To view two worksheets in the same workbook side by side

• Open the workbook that contains the worksheets that you want to view at the same time.
• On the View tab, in the Window group, click New Window. Excel opens a second instance of the same workbook.
• On the newly opened workbook, click the View tab, in the Window group, click View Side by Side.

• To scroll both worksheets at the same time, click Synchronous Scrolling. This option is available only when View Side by Side is turned on.

To view two worksheets of different workbooks side by side

• Open both of the workbooks that contain the worksheets that you want to compare.
• On the View tab, in the Window group, click View Side by Side.

Note: If you keep more than two workbooks open, Excel displays the Compare Side by Side dialog box.

• From the Compare Side by Side dialog box displayed, click the workbook that contains the worksheet that you want to compare with your active worksheet, and then click OK.
• To scroll both worksheets at the same time, click Synchronous Scrolling in the Window group on the View tab.

Related Topics:

Customizing and Adding Commands to the Quick Access Toolbar in Excel 2007

How to Install and Uninstall Add-ins in Excel 2007?

Guide to Highlight and Remove Duplicates Values in Excel 2007

How To Protect Excel Worksheet or Workbook with the Password?

Using the Watch Window Feature in Microsoft Excel 2007!

How to Create Excel 2007 Drop Down List? - The Simple Way

How to Create the Excel 2007 Data Validation Rules?

Can't find what you're looking for? Try Google Search!

Custom Search

Back to Top

You're viewing the Excel 2007 multiple worksheets feature info page, click here to go back to the Home Page

Add To Your Social Bookmarks: Blink Del.icio.us Digg
Furl Google Simpy Spurl Technorati Y! MyWeb