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.
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.
Guru Spotlight |
Alexis Niki |