"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.

Excel arrange windows 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.

Excel 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.

Excel Compare Side by Side

  • 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: add to BlinkBlink add to Del.icio.usDel.icio.us add to DiggDigg
add to FurlFurl add to GoogleGoogle add to SimpySimpy add to SpurlSpurl Bookmark at TechnoratiTechnorati add to YahooY! MyWeb


Google Search:

Custom Search

Recommended Books:

Click on the image to view the details of the book.
Excel 2007 ebook
The Ultimate Guide to
Excel 2007!


PowerPoint 2007 ebook
The Ultimate Guide to
PowerPoint 2007




XML RSS
What is this?
Add to My Yahoo!
Add to My MSN
Add to Google


Enjoy This Site?
Then why not use the button below, to add us to your favorite bookmarking service?

Copyright © www.msoffice-tutorial-training.com. All Rights Reserved.