Hi Fellow Excel Addict,

Summer is quickly coming to an end here in Canada as my two girls head back to school today - grade 8 and grade 11. We all enjoyed an excellent summer but now they are anxious to get back to school, though I'm sure that feeling will be short lived.

Welcome to another edition of "Spreadsheet Tips From An Excel Addict." I hope you will enjoy my tips this week. So please, try them out and please let me know what you think. I really do love hearing from people from all around the world.

Have an awesome week and I'll see you soon.

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/

Here's another one of my 'mouseless tips.'

To quickly insert a comment in the current cell, simply press SHIFT+F2 and start typing. Don't like where it is positioned? Don't touch that mouse! Just press the ESC key and use the arrow keys on your keyboard to move the comment around. When you are done with the comment, press the ESC key to close the comment.

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 really want to make a specific piece of data on your worksheet stand out, using a linked AutoShape such as an arrow, star or banner is a great trick to use.

To create an AutoShape, you will need to use the Drawing toolbar. If the Drawing toolbar is not visible, select View, Toolbars, Drawing to display it. On the Drawing toolbar, click the AutoShapes button and choose a shape. Many of these shapes will allow you to type data directly in the object. With others, you can link the object to the contents of a worksheet cell. That's what I'm going to show you now.

Once you choose a shape, click in the area of your worksheet where you want to place the shape and drag to make the shape the desired size (you will be able to move and resize it later). Move your mouse pointer to the edge of the Auto shape and click once to select it. (If you see a blinking I-beam in the middle of the shape you will need to click the edge of the shape again.) Now click the equal sign in the Formula Bar. If you cannot click the equal sign on the Formula Bar, it means that particular shape doesn't allow you to link it to a cell -- try another shape.

After you click the equal sign (or type the equal sign on your keyboard), click the cell on your worksheet that you want to link the shape to or type the cell address in the formula bar and then press Enter. You should now see the data from the linked cell shown within the AutoShape, and in the Formula Bar you should see the address of the linked cell. As the data in the linked cell changes, the data in the AutoShape will also change.

Now you'll probably want to format the AutoShape's background, alignment, etc.. Right click on the AutoShape and selecting Format Autoshape, make the desired formatting changes.

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.

These days the Internet is so important to all of us, we always want quick access to it. One of my favorite timesavers is to add an Address bar to the taskbar at the bottom of my screen so that it is always visible no matter which program I'm working in.

To add the Address bar simply right click on any gray area of the taskbar and choose Toolbars, Address. You can resize the Address bar by dragging the left edge of the bar.

Now whenever you need quick access to a particular website, there's no need to minimize any windows, just type the address in the Address bar and press Enter.