View Two Sheets of a Workbook Simultaneously


If you want to view more than one page of a workbook, you can use the "New Window" option, which is located in the 'View' menu of Excel 2007 or the 'Window' drop-down menu of Excel 2003. This opens up a second window for the current workbook, so that you can view different worksheets of the same workbook in one Excel viewer.
The best way to display both windows is to use Excel's automatic 'Arrange' command (again, located in the 'View' menu of Excel 2007 or the 'Window' drop-down menu of Excel 2003). Alternatively, you could size the windows manually in the Excel viewer.
Having two windows open for one Excel file is much more convenient than having to repeatedly switch from one worksheet to the other!

Comments

Popular posts from this blog

50 Excel VBA Oral Interview Questions