"How To Excel" Mini-Tutorials
by TheExcelAddict.com
"Helping Average Spreadsheet Users Become Local Spreadsheet Experts"

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.

Here's how:

  1. Go to the first sheet and range that you want to work with.
  2. Open a new window of the same workbook by clicking Window, New Window. You will notice in the Title Bar of the window there is a number following the filename indicating which window it is.
  3. In the second window browse to the other sheet and range that you want to work with.
  4. Now, to get both of these windows in the same view, select Window, Arrange, select Tiled and put a check mark in 'Windows of active workbook' and click OK.
Now that you've got both working areas in view, you can easily cut, copy, past, move and much more between the windows. What's really cool is that you can easily drag and drop from one window to another. Remember that when dragging and dropping you hold down the CTRL key to copy the selection (notice the small plus sign when you're dragging) otherwise the selection will be moved.

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.

Why not print (CTRL+P) this tip and share it with your friends and associates?

Get more time-saving tips just like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict". Subscribe at the www.TheExcelAddict.com/Newsletter.htm.
You'll be amazed how much time you'll save just by learning a few of these tips.

Copyright 2003 All Rights Reserved by Francis Hayes (The Excel Addict)

If you came to this page from my Excel Mini-Tutorials page, click here to close this window,
otherwise click here and you'll find lots more time-saving Excel tutorials like this one.