View Two Excel Sheets Simultaneously / together

How to View Two Sheets of a Workbook Simultaneously / together in MS Excel.





Sometimes we need to see more than one sheets of a Excel Workbook together / simultaneously, so if there is any requirement like this how can you do that in Microsoft Excel. Here is a very simple and easy way to do this.

1-New Window

So if you want to view more than one page of a workbook, you can use the "New Window" option. Many Excel users never use this option in their whole life. In Excel 2007/2010 "New Window" option is located in the 'View' menu or in Excel 2003 located in the 'Window' drop-down menu. This "New Window" option opens up a second window for the current workbook, so that you can view different worksheets of the same workbook in one Excel viewer.

Arrange Window

You can arrange your windows as you want like Tiled, Horizontal, Vertical, Cascade. To arrange Excel sheet windows use Excel's automatic 'Arrange' command which is also located in the 'View' menu of Excel 2007/2010 or the 'Window' drop-down menu of Excel 2003. Alternatively, you could size the windows manually in the Excel viewer.

It is much more convenient having two windows open for one Excel file than having to repeatedly switch from one worksheet to the other!