Read this tip to make your life smarter, better, faster and wiser. LifeTips is the place to go when you need to know about Excel 2000 and other Software topics.
Constantly switching between worksheets can be frustrating and can really damage your productivity. To show more than one worksheet on screen at the same time, follow these simple steps:
1) From the Window menu, select New Window (do this for each additional worksheet which you want to view)
2) Select Arrange from the Window menu
3) Put a tick in the 'Windows of Active Workbook' box
4) Choose the way you want your window arranged (tiled, vertical etc) and press OK
Each window will now be displayed separately and you can show a different worksheet in each one.