20 Mar 2009

How to open 2 worksheets at the same time in Excel 2003

So as i am doing an Excel course i thought i would share things as i learn them so expect lots of Excel tips soon...
So ever wanted to open 2 sheets of the same Workbook in the same Excel window.  Well to do this follow the below
Open the workbook normally and then click on Windows (Alt+w) and select New Window (Alt+n)
Your workbook name will show as name:1 or name:2 
Now if you goto the Window menu again and select Arrange and select Horizontal this will display both sheets.  If on the bottom sheet you select sheet 2 you will then see Sheet1 at the top and Sheet2 at the bottom.
 

No comments:

Post a Comment