View more than one Excel worksheet at once

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 97 and other Software topics.

How do I display more than one worksheet at the same time?

View more than one Excel worksheet at once

Constantly switching between Excel 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.



Nobody has commented on this tip yet. Be the first.


URL: (optional)


Not finding the advice and tips you need on this Software Tip Site? Request a Tip Now!

Guru Spotlight
Joe Wallace