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