Hi Fellow Excel Addict,

Coaching youth soccer is a real time commitment. It is sure eating up a lot of my time this summer but it is something I love doing so I guess there's nothing wrong with that.

I also love passing on my time-saving Excel tips to you, but every once in a while I get a little behind. This week I'm a day late so here they are now. I hope you find something you can use in here.

Have a productive week.

Keep on Excelling,
Francis J Hayes (The Excel Addict)

P.S. VERY IMPORTANT Please remember to include "TheExcelAddict" in the Subject line of any email you send me. This will help it stand out in the flood of junk email I have been receiving lately.

DISCOVER NEWFOUNDLAND AND LABRADOR, CANADA:
This is where I grew up: http://www.brigus.net/
This is where I now live: http://www.conceptionbaysouth.ca/
This is my beautiful province: http://www.gov.nf.ca/tourism/

By now you are probably familiar with using the Fill Handle. But here's something you may not know. You can also use the Fill Handle to clear the contents of a range of cells by dragging it backwards over the current selection.

Try it. Select a range of cells that contain the data you want to clear. Now drag the Fill Handle backwards over the selected cells. You'll notice that the cells turn gray as you drag. Release the mouse button and the cell contents are gone. The neat part about this is that the cell formats are not affected.

Jim Rohn's Weekly E-Zine is a free weekly publication dedicated to providing valuable insights and information that can help empower and improve both your business and personal life. Find out more at http://www.TheExcelAddict.com/rd/jimrohn.htm.

If you need to view or work with different parts of your worksheet at the same time, you can, by using Excel's split screen feature. Splitting the screen allows you to split a worksheet into two separate panes, either vertically or horizontally, that can be scrolled separately.

First, locate the two split boxes. One is the small box immediately above the vertical scroll bar arrow and the other is immediately to the right of the horizontal scroll bar arrow. When you position the mouse pointed over the split box, the pointer will change to a two-headed arrow.

To split the screen horizontally:

1. Position the mouse pointed over the split box above the vertical scroll bar.
2. Click and drag the your mouse pointer down to where you want to split the screen.

1. Position the mouse pointed over the split box to the right of the horizontal scroll bar.
2. Click and drag the your mouse pointer left to where you want to split the screen.

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.

If you download files from the Internet, you will have noticed that many of these downloadable files are in EXE file format. Often these files are self-extracting zip files or self-contained programs.

If you download an EXE file to your Downloads folder and, later on decide you want to drag it to another folder, you will find that by default, Windows creates a Shortcut in the location that you drag the file to. Most people get around this problem by using Cut and Paste. An easier way to avoid this behaviour by holding down the Shift key while dragging the file. Shift tells Windows you want to MOVE the file.