Add A New Window For A Better View
Sometimes you may wish that you could see two parts of your workbook at the same time. Who says you can't be in two places at the same time? I have a great tip that will let you do just that.
Let's assume you have a workbook with several sheets and you want to work back and forth between two sheets. It can get a little tedious switching between sheets, especially if you need to do it often. I have a solution that will allow you, not only to see two separate parts of your workbook at the same time, but to easily work between them with virtually no switching back and forth.
Excel allows you to open a new window of your workbook. It may look like another workbook but actually it is just another view of the same workbook. But even working between two windows doesn't help much. The trick is to get both of these windows in your view at the same time.
Oh, I almost forgot. When you're finished working with both windows, close the second one (click the Close button on the top right corner of the window) and Maximize the original window.
Now don't just read this tip. Try it. This really is a great time-saver.