Welcome to
SPREADSHEET TIPS FROM AN EXCEL ADDICT
(Online Edition)

Helping Average Spreadsheet Users
Become Local Spreadsheet Experts

A Free Weekly Publication of TheExcelAddict.com

Publication Date: October 14, 2003


I respect your privacy and promise not to abuse this privilege. This newsletter is sent ONLY to those who have Subscribed and NEVER uses unethical methods to gain new subscribers. If you no longer wish to receive this newsletter, you'll find simple removal instructions at the bottom of every newsletter.

CONTENTS
  1. Editor Notes
  2. Excel "Quick Tip"
  3. T-Shirt Contest
  4. "How To Excel" Mini-Tutorial
  5. Spreading The Word
  6. "Non-Excel" Tip
  7. Subscription Management

Click for * Important Notice * to subscribers who haven't
been receiving my newsletters regularly in your email.


EDITOR NOTES      Top

Hi Fellow Excel Addict,

Throughout the world many cultures celebrate a bountiful harvest through festivals and celebrations. On Monday Canadians, myself included, celebrated the feast of Thanksgiving. I hope you had a great week too. We all can find much to be thankful for.

It's great to see so many people signing up to my newsletter. This a simple and powerful way to share with others something that can benefit them also. Thanks for your help.

I hope you enjoy this weeks tips.

Have a great week.

To Your Success!
Francis Hayes (The Excel Addict)


EXCEL "QUICK TIP"      Top
Editing Hyperlinks
If you use Hyperlinks in your worksheet, you may find it a bit tricky to edit them once the hyperlink has been created. When you click on the cell containing the hyperlink, Excel automatically follows the hyperlink. Here are a couple of ways you can safely edit your hyperlinks.

  1. Use the arrow keys to move to the cell and then press F2 to edit the displayed text for the hyperlink.
  2. Click on the cell with the mouse, holding the mouse button down for a second or two, and then edit the value in the formula bar, or
  3. Right-click on the cell and choose Hyperlink, Edit Hyperlink.
If you're not familiar with hyperlinks, see my previous tip How To Create A Hyperlink To Another Workbook.

Click here for more Excel "Quick Tips".

T-SHIRT CONTEST      Top
Every month I am giving away a really cool t-shirt to one of my newsletter subscribers. You can sneak a peek at my t-shirt here.

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.


"HOW TO EXCEL" MINI-TUTORIAL      Top
Hiding Unused Rows and Columns
As you may or may not know (or even care), an Excel worksheet contains 16,777,216 cells (65,536 columns x 256 rows). Most Excel worksheets use only a very tiny portion of that area. It may be useful to hide the area that you aren't using to keep from scrolling off the edge of your work area.

Here's how:

  1. Select a cell in a row beneath the work area of your worksheet.
  2. While holding down the CTRL + SHIFT keys press the down arrow on your keyboard. This will select a range of cells from the cell you selected down to the last row of the worksheet (i.e. row 16,556).
  3. Select Format, Row, Hide.
  4. Next, select a cell in a column to the right of the work area of your worksheet.
  5. While holding down the CTRL + SHIFT keys press the right arrow on your keyboard. This will select a range of cells from the cell you selected over to the last column on the far-right side of your worksheet (i.e. Column IV).
  6. Select Format, Column, Hide.
You will notice that the cells outside your work area are grayed out. Be aware that if you use the Select All button (the grey rectangle in the upper-left corner of the worksheet where the row and column headings meet) before adjusting your row heights or column widths, this will unhide the previously hidden rows or columns. To adjust the row heights or column widths without unhiding the other rows and columns, select only the visible row or column headings first.

Click here for more "How To Excel" Mini-Tutorials.

SPREADING THE WORD
Every week this newsletter is being read by Excel Addicts in: Canada, USA, Britain, Germany, Norway, Brazil, Saudi Arabia, China, Australia, South Africa, Jordan, Singapore, the Philippines, South Korea, India, Thailand, The Netherlands, Ecuador, Spain, Argentina, Afghanistan, Venezuela, Iraq, Kuwait and Viet Nam.

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.

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


BONUS "NON-EXCEL" TIP      Top
Re-organize Your Programs Menu
If you're like me, you probably have dozens of programs installed on your computer resulting in a very long Programs listing on your Start Menu. Here's a great tip to help you get things organized by grouping your programs into categories.

  1. Open Windows Explorer.
  2. Browse to and select the Windows\Start Menu\Programs folder.
  3. Create a new folder (File, New, Folder) for each category you want (e.g. Work, Games, Graphics, Utilities, Music etc.).
  4. Now drag the shortcuts for your programs and drop them into the appropriate folder.
You'll find that your programs are much easier to find, plus it's looks a whole lot tidier.

Click here for more Bonus "Non-Excel" Tips

SUBSCRIPTION MANAGEMENT      Top
This online version of Spreadsheet Tips From An Excel Addict is available only to subscribers of my free email newsletter. Each week, in addition to the email version of my newsletter, you will be emailed a special link to the online version. If you haven't subscribed yet you can click here to subscribe NOW or you can send a blank email to TheExcelAddict@DemandMail.com


Suggest tips to tips@TheExcelAddict.com Send testimonials to kudos@TheExcelAddict.com Send your suggestions for 'out-of-the-ordinary' uses for Excel to coolstuff@TheExcelAddict.com Any other comments send to francis@TheExcelAddict.com
"Spreadsheets Tips From An Excel Addict" is a FREE weekly publication of TheExcelAddict.com. Copyright 2003, Francis J. Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630