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: March 31, 2004


I respect your privacy and promise not to abuse this privilege. This newsletter is sent only to those who have requested it. If you no longer wish to receive my tips, you'll find simple instructions at the bottom of every newsletter.

CONTENTS
  1. Greetings From Canada
  2. Excel "Quick Tip"
  3. Empower And Improve
  4. Referral Contest
  5. "How To Excel" Mini-Tutorial
  6. Excel Addicts Around The World
  7. "Non-Excel" Tip
  8. Subscription Information

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


GREETINGS FROM CANADA Top

Hi Fellow Excel Addict,

I hope you're having a fantastic week. I've got some more tips this week that I hope you're going to enjoy.

Last week's tips showed you how to 'Hide Excel's Gridlines', 'Copy Formulas And Maintain The Original Cell References', and how to 'Print Files Directly From Windows Explorer.'

Did you find these tips helpful? These are tips that I've learned over the years and I use them every day to help turbocharge my productivity. My hope is that, as you master these tips one-by-one, you will see your productivity increase also.

Wishing you an EXCELlent week.

To Your Success!
Francis Hayes (The Excel Addict)

EXCEL SCREENSAVERS: Don't forget to check out the cool Excel screensavers in the new downloads section of my website. http://www.TheExcelAddict.com/downloads

DISCOVER NEWFOUNDLAND AND LABRADOR, CANADA:
This is my hometown: http://www.conceptionbaysouth.ca/
This is my beautiful province: http://www.gov.nf.ca/tourism/


EXCEL "QUICK TIP" Top
Moving The Cell Pointer Around A Selected Range

Often when you have selected a range of cells, you need to move the activecell around the range. Here are some shortcuts for moving around the selection.

  1. Move Down - Press Enter.
  2. Move Up - Press Shift+Enter.
  3. Move Right - Press Tab.
  4. Move Left - Press Shift+Tab.
  5. Move from corner to corner - Press Ctrl+ (CTRL+period).
Just select a range of cells and try this. Can you see how this would make the job of inputting data into a range of cells much easier?

Note that the first four shortcuts will work even when you don't have a range selected.


EMPOWER AND IMPROVE Top
Over the past year I have discovered that in addition to increasing ones business knowledge and working on improving ones career it is equally important to work on improving ones self.

Jim Rohn says, "What you don't know WILL hurt you." I wish I had known this when I was younger. I can honestly say that, over the past two years, the wisdom of Jim Rohn has had a major positive affect on my life, both personally and in my business. If you are looking to improve yourself personally and/or professionally, Jim Rohn can help you just as he has helped millions of others around the world.

-- Personally recommended by Francis Hayes (The Excel Addict)

If you would like to benefit from the wisdom of 'America's Foremost Business Philosopher' check out his FREE weekly E-Zine.

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.


REFERRAL CONTEST Top
Each month I select a name from everyone who refers my website or newsletter to a friend or colleague and they receive a cool prize from TheExcelAddict.com.

All you have to do to qualify each month is send an email to your Excel friends and associates recommending my newsletter and website. Include a BCC to referral@TheExcelAddict.com and for each person that you refer, your name will go into the draw. Please, recommend only to people you know and who are Microsoft Excel users.

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 draw. The more Excel friends you refer, the more chances you have of winning, 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 Referral Contest 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.

Referral Contest Winners
February
January
December
November
October
September
August
July
June
Ashley Rankine, Perth, Australia
Luis Bolivar, Maracaibo, Venezuela
Joseph Mathew, Dubai, United Arab Emirates
Alexandre Gusmao, Lisbon, Portugal
Apollo Tigalo, Angeles City, Philippines
Jim Henderson, California, USA
Beki Chambers, Indiana, USA
Keith Bannister, North Carolina, USA
Lisa Hobbs, Pennsylvania, USA


"HOW TO EXCEL" MINI-TUTORIAL Top
Change The Format Of Excel's Comments

In order to change the format of an individual comment in Excel, you format it the same as if it was a text box.

  1. Right click on the cell containing the comment.
  2. Select Show Comment.
  3. Right-click on the border of the comment and select Format Comment.
  4. Make formatting changes the same as with any text box in Excel.
  5. Right-click on the border of the comment and select Hide Comment.
You can also change the default format for all comments in Excel. However, it has to be done from outside of Excel. Be aware that to change the default format for Excel comments, you will also be changing the default format for all tool tips (those little notes that popup every time you pause the cursor over a tool button) in Windows.

Here's what you need to do:

  1. Go to your Windows Desktop (Windows key + M).
  2. Right click on the desktop and choose Properties from the popup menu.
  3. Click the Appearance tab.
  4. From the Item dropdown list, select ToolTip.
  5. You can now choose a new background color, font face, font color, font size, bold, or italics.
  6. Click OK to accept the changes.
Note that these changes will apply to across all Windows' ToolTips as well as Excel's comments.

Thanks to Tim Owens for the tip suggestion.

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

SPREADING THE WORD
Every week this newsletter is being read by Excel Addicts in: Albania, Antarctica, Antigua and Barbuda, Argentina, Australia, Bahrain, Brazil, Canada, Chile, China, Colombia, Costa Rica, Cote d'Ivoire, Croatia, Cuba, Cyprus, Denmark, Dominican Republic, Estonia, Finland, France, Germany, Great Britain, Guam, Hong Kong, Hungary, India, Indonesia, Ireland, Israel, Italy, Jamaica, Japan, Kazakhstan, Korea, Malaysia, Malta, Mexico, Nepal, The Netherlands, New Zealand, Nicaragua, Nigeria, Norway, Pakistan, Peru, Philippines, Portugal, Puerto Rico, Reunion, Romania, Saudi Arabia, Singapore, Slovenia, South Africa, Spain, Sweden, Switzerland, Turkey, Uganda, Ukraine, United Arab Emirates, United States, Vanuatu, Venezuela, 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.

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.


BONUS "NON-EXCEL" TIP Top
Quickly Access Your Computer Display Settings

If you like to change your desktop wallpaper or screensaver frequently to keep things fresh, you more than likely go through the steps Start, Settings, Control Panel, and Display.

A much quicker way to access the Display Properties dialog box is to

  1. Right-click on any empty area of the desktop
  2. Choose Properties.

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


Send tip suggestions 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 © 2004, Francis J. Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630