Hi Fellow Excel Addict,

I hope things are well with you this week. I know I'm really enjoying the fall here in Newfoundland. We are continuing to be blessed with above average weather for this time of the year. Just this past weekend I even held a couple of soccer practices for my girls under-14 all-stars - outdoors. The weather was beautiful.

Well, this has been a record-setting week for Spreadsheet Tips From An Excel Addict. Thanks to a great referral by one of my recent subscribers, there has been a flood of new subscribers to this newsletter. And they're still coming in. Thanks Larry.

I encourage you to think of someone else who uses Excel and could use a little (or a big) boost in productivity. Forward a copy of this newsletter to them. I'm sure they will appreciate it.

There are some great tips below, so read them and, more importantly, practice them. I hope you have super week.

To Your Success!
Francis Hayes (The Excel Addict)

You can quickly scroll through the pages of a multi-page workbook in PrintPreview by using the vertical scroll-bar. To quickly get to a specific page, watch the page numbers in the StatusBar (bottom left corner) as you're scrolling. Note, however, that when you are in Zoom mode in Print Preview, the vertical scroll bar scrolls only through the current page.

If you subscribed to this newsletter prior to this current month, you can still get your name in for the draw each month by helping me share this newsletter.

All you have to do each month is click here to recommend my newsletter and website to a friend. For each person that you refer, your name will go into the t-shirt draw. The more Excel friends you refer, the more chances you have of winning a t-shirt. But please, recommend it only to people you know and who are Microsoft Excel users.

If you use the 'Tell A Friend' link at www.TheExcelAddict.com you could win $10,000 and you will also qualify for my t-shirt draw.

*** Each monthly winner will be notified by email and will have 10 days to reply with a shipping address. If I don't receive a reply within 10 days, another name will be drawn.

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.

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.

There are tens of millions of other Microsoft Excel users all over the world. The vast majority of them have a very limited knowledge of Excel's capabilities. My goal is to share this information with everyone I possibly can and help them to benefit from Excel's amazing capabilities.

Please help me spread the word about my newsletter. If you know other Excel users, please tell them about "Spreadsheet Tips From An Excel Addict". I'm sure they'll appreciate it.

Maybe you know someone who supervises or employs many Excel users. That's where your referral could have a big impact.

VERY IMPORTANT: Please refer only people you know personally, who use Microsoft Excel and would benefit from this newsletter.

I see this almost every day and it drives me crazy. Someone is looking for a file on their computer but they don't remember where it is or what the filename is. They have a hard copy but there's no filename printed on it.

Windows makes it so easy to find files on your computer that it's a crime that most people don't know how to do it. Sometimes I will just stand back and watch people look for a file on their computer to see how they do it. At times I've seen three people huddled around a computer giving their suggestions of where to look.

Then I step forward and say, "Let me look. Oh, here it is." In a minute or less, depending on the speed of your computer, you should be able to find any file on your hard drive as long as you know something of what's in the document.

Click on Start, Find, and then 'Files or Folders' to bring up the 'Find All Files' dialog box.

If you know the name of the file but don't remember which folder it is in, type the name, or part of the name, in the 'Named' field. If you don't know the name of the file but do know some text contained within the file, type that text in the 'Containing text' field. There are other options on the Date and Advanced tab which you can experiment with at another time.

Make sure the location in the 'Look in' field contains the sub- folders where the file you're looking for may be located (i.e. you may select C: to search your whole hard drive).

Now click 'Find Now' and in a short time you will be given a list of files matching your criteria.

Remember this tip because some day you're going to need it. How would you like to recreate a 20 page document because you didn't know how to find it on your computer?