April 24, 2009, Newsletter Issue #304: View more than one Excel worksheet at once

Tip of the Week

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.

About LifeTips

Now one of the top on-line publishers in the world, LifeTips offers tips to millions of monthly visitors. Our mission mission is to make your life smarter, better, faster and wiser. Expert writers earn dough for what they know. And exclusive sponsors in each niche topic help us make-it-all happen.

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

Guru Spotlight
Lynne Christen