How to View Multiple Worksheets at the Same Time in Excel 2007?
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.
